MySQL

From DuncanWiki
Jump to: navigation, search
[root@gypsy ~]# service mysqld start
Initializing MySQL database:  Installing MySQL system tables...
OK
Filling help tables...
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 gypsy password 'new-password'
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
                                                          [  OK  ]
Starting MySQL:                                            [  OK  ]
[root@gypsy ~]# read j
j0956e45SBHNJPK098768574u6tFHJJBHLOIY087jkhg
[root@gypsy ~]# /usr/bin/mysqladmin -u root password $j
[root@gypsy ~]# /usr/bin/mysqladmin -u root -h gypsy password $j
/usr/bin/mysqladmin: connect to server at 'gypsy' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@gypsy ~]# /usr/bin/mysqladmin -u root -h gypsy password $j -p
Enter password: 
[root@gypsy ~]# service mysqld restart
Stopping MySQL:                                            [  OK  ]
Starting MySQL:                                            [  OK  ]
Personal tools