Revision: 41209
Updated Code
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
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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