MySQL Server Tips
How to Install MySQL Server on RHEL 5.3
sudo yum install mysql-server mysql
sudo chkconfig –add mysqld
sudo chkconfig –level 2 mysqld
sudo chkconfig –level 3 mysqld
sudo chkconfig –level 4 mysqld
How to Set the MySQL Root User Password
mysql -u root
mysql> SET PASSWORD FOR ‘root’@'localhost’ = PASSWORD(‘yourpassword’);
mysql> FLUSH PRIVILEGES;
mysql> exit
How to Create a Database
mysql -u root -pyourpassword
mysql> CREATE DATABASE yourdatabase;
Creating a User With Access to New Database
mysql -u root -pyourpassword
mysql> GRANT ALL PRIVILEGES ON yourdatabase.* TO ‘yourusername’@'localhost’ IDENTIFIED BY ‘yourpassword’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit
To Create a User With Fewer Privileges Limited to New Database
mysql -u root -pyourpassword
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON yourdatabase.* TO ‘yourusername’@'localhost’ IDENTIFIED BY ‘yourpassword’;
mysql> FLUSH PRIVILEGES;
mysql> exit
To Create a User With Access to New Database From any Host
mysql -u root -pyourpassword
mysql> GRANT ALL PRIVILEGES ON yourdatabase.* TO ‘yourusername’@'localhost’ IDENTIFIED BY ‘yourpassword’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit
To Create a User With Access to database from any host
mysql -u root -pyourpassword
mysql> GRANT ALL PRIVILEGES ON yourdatabase.* TO ‘yourusername’@'%’ IDENTIFIED BY ‘yourpassword’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit
How to Backup a Database Instance From mysqldump Command
/bin/mysqldump -u username -ppassword –databases databasename >/tmp/databasename.sql
How to Restore a Database Instance From Command Line
mysql -u username -ppassword databasename < /tmp/databasename.sql