Advanced Search

Return to Snippet

Revision: 41209
at February 14, 2011 09:08 by jwaldeck
Updated Code 
mysql
SHOW DATABASES;
mysql -u root -p 
SET PASSWORD FOR root@localhost=PASSWORD('#PasswordHere#');
FLUSH PRIVILEGES;
CREATE DATABASE #NAME#;
DROP DATABASE #NAME#;

<!-- Granting user privileges -->
GRANT ALL PRIVILEGES ON #databaseName#.*
TO 'username'@'localhost'
IDENTIFIED BY '#userpassword';
SHOW GRANTS FOR '#username#'@'localhost'

mysql -u #UserName# -p #databaseName#
SHOW TABLES;

Revision: 41208
at February 14, 2011 07:25 by jwaldeck
Initial Code 
mysql
SHOW DATABASES;
mysql -u root -p 
SET PASSWORD FOR root@localhost=PASSWORD('#PasswordHere#');
FLUSH PRIVILEGES;
Initial URL 









Initial Description














Initial Title





MySQL from Command Line









Initial Tags














Initial Language





MySQL