Configuring MySQL

The following is how I set up MySQL on wharf.

1. First, ensure mysql is installed: ls /etc/init.d/my*
2. Now, make mysql start on boot: sudo /sbin/chkconfig --level 35 mysqld on
3. Start the mysql server: sudo /etc/init.d/mysqld start
4. Make MySQL more secure: sudo /usr/bin/mysql_secure_installation
5. Log into mysql as root: mysql -u root -p [to be entered by prompt]
6. Add another mysql user:
   mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'newuserpass';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO 'newuser'@'%';
mysql> FLUSH PRIVILEGES;
7. Exit mysql: mysql> exit
8. Test: mysql -u <newuser> -p <newuserpass>

Tags: chkconfig, configure, init.d, install, mysql, mysqld