konfigurasi mysql di slackware linux

jika kita install full slackware, maka paket mysql sudah terinstall. cek apakah sudah terinstall atau belum ?

root@slackware:~# ls /var/log/packages/ | grep mysql
mysql-5.0.51b-i486-1


jika belum install paket mysql, paket mysql ada di cd / dvd distro mysql :
root@slackware:~# installpkg mysql.*.tgz

*buat database & table mysql*
#mysql_install_db

*Ubah owner dari direktori data MySQL ke user dan group “mysql”*
#chown -R mysql.mysql /var/lib/mysql/
# chmod -R 755 /var/lib/mysql/



*jalankan mysql, terlebih dahulu init script nya dirubah executable:*
#chmod +x /etc/rc.d/rc.mysqld
# /etc/rc.d/rc.mysqld start


*beri password mysql untuk user root*
# mysqladmin -u root password password_anda

*akses ke mysql*
# mysql -u root -p
Enter password:

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.0.51b Source distribution

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.
mysql>


1 comments:

wa2nlinux said...

Sep ... kenapa pindah ke blogger ?