Tuesday, February 01, 2011
mysql for redhat
for redhat:
service mysqld start/stop
mysql -u root -h localhost
(should change password after first login)
show databases;
use database;
show tables;
# mysql -u root -p
use mysql;
INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
flush privileges;
service mysqld start/stop
mysql -u root -h localhost
(should change password after first login)
show databases;
use database;
show tables;
# mysql -u root -p
use mysql;
INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
flush privileges;