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;
Comments: Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?