MYSQL di Slackware 13.0

pengen belajar,eh ternyata mysql nya belum di configurasi,pantesan mau masuk database gak bisa-bisa,liat2 di google ternyata gini toh,
thanks to all slakwarez...

jadi root:

fazrie@darkstar:~$su -
 
jalankan perintah mysql_install_db:

root@darkstar:~# mysql_install_db 
Installing MySQL system tables... 
091211 15:16:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295                                                                                  
091211 15:16:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295                                                                                  
OK                                                                                             
Filling help tables...                                                                         
091211 15:16:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295                                                                                  
091211 15:16:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295                                                                                  
OK                                                                                             

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'           
/usr/bin/mysqladmin -u root -h darkstar password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.             

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &    

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl              

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com                                         
Support MySQL by buying support/licenses at http://shop.mysql.com

rubah permission :

root@darkstar:~# chmod -R 755 /var/lib/mysql/                    
root@darkstar:~# chown -R mysql.mysql /var/lib/mysql/ 
root@darkstar:~# chmod -R 755 /etc/rc.d/rc.mysqld           
root@darkstar:~# /etc/rc.d/rc.mysqld restart                     
nohup: redirecting stderr to stdout             
Starting mysqld daemon with databases from /var/lib/mysql        

set password untuk root

root@darkstar:~# /usr/bin/mysqladmin -u root password 'adminmysql'
root@darkstar:~# logout                                           
fazrie@darkstar:~$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.84 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

mysql> exit

Comments

  1. mas kura-kura, hehehe
    kok dalam etc/rc.d/ ngga ada file rc.mysqld jadi ngga bisa d restart

    bash-3.1# /etc/rc.d/rc.mysqld restart
    bash: /etc/rc.d/rc.mysqld: Permission denied

    mohon bantuannya...

    ReplyDelete
  2. mas takedown,
    pastikan permission di
    /etc/rc.d/rc.mysqld nya dirubah sehingga bisa dieksekusi.

    bash-3.1# chmod 755 /etc/rc.d/rc.mysqld

    setelah itu jalankan service mysql-ny
    :)

    ReplyDelete

Post a Comment

Popular posts from this blog

authentication failure using SSH pam_unix(sshd:auth): authentication failure;

Howto configure SPLUNK Universal Forwarder

openvpn howto make OCSP server using OpenSSL [Part2]