Started with system database of mysql<\/p>\n
Create a database: Corresponding Unix system command To add password To export database To add a user to a database: To add a user that can access from other client machines, use % as the host To change password, use To change permissions, use or — special for loading file To check the error such as the infamous “ERROR 1005 (HY000)”, use Started with system database of mysql $ mysql -uroot -ppassword mysql Create a database: mysql> CREATE database mydb mysql> drop database mydb; mysql> show databases; Corresponding Unix system command $ mysqladmin drop mydb $ mysqlshow To add password $ mysqladmin password xxxx To export database $ mysqldump -u myuser -pmypass mydb > exl.sql To add … <\/p>\n$ mysql -uroot -ppassword mysql<\/code><\/p>\n
\n
\nmysql> CREATE database mydb
\nmysql> drop database mydb;
\nmysql> show databases;
\n<\/code><\/p>\n
\n
\n$ mysqladmin drop mydb
\n$ mysqlshow
\n<\/code><\/p>\n
\n
\n$ mysqladmin password xxxx
\n<\/code><\/p>\n
\n
\n$ mysqldump -u myuser -pmypass mydb > exl.sql
\n<\/code><\/p>\n
\n
\nmysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP on mydb.* to 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
\n<\/code>
\nor
\n
\nmysql> INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','mypassword');
\n<\/code><\/p>\n
\n
\nmysql> GRANT SELECT on db1.* to 'myuser'@'%' IDENTIFIED BY 'mypassword';
\n<\/code><\/p>\n
\n
\nmysql> update user set password=PASSWORD(\u00e2\u20ac\u0153NEW-PASSWORD\u00e2\u20ac\u009d) where User=\u00e2\u20ac\u2122myuser\u00e2\u20ac\u2122;
\n<\/code><\/p>\n
\n
\nmysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
\nmysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP on mydb.* to myuser;
\n<\/code><\/p>\n
\n
\nmysql> GRANT ALL on mydb.* to myuser
\nmysql> FLUSH PRIVILEGES;
\n<\/code><\/p>\n
\n
\nmysql> GRANT FILE on *.* to myuser
\nmysql> LOAD DATA INFILE '\/mypath\/myfile' INTO TABLE mytable FIELDS TERMINATED BY '\\t' LINES TERMINATED BY '\\n';
\n<\/code><\/p>\n
\n
\nmysql> SHOW ENGINE INNODB STATUS
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"