1. Change root user



su -
## OR ##
sudo -i


2. Install Remi repository



## CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm


 

3. Check Available MySQL versions



yum --enablerepo=remi,remi-test list mysql mysql-server


Output:


Loaded plugins: changelog, fastestmirror, presto, refresh-packagekit
...
remi                                                            | 3.0 kB     00:00     
remi/primary_db                                                 | 106 kB     00:00     
Available Packages
mysql.i686                               5.5.37-1.fc18.remi                        @remi
mysql-server.i686                        5.5.37-1.fc18.remi                        @remi



4. Update or Install MySQL 5.5.37



yum --enablerepo=remi install mysql mysql-server


 

5. Start MySQL server and autostart MySQL on boot



/etc/init.d/mysqld start ## use restart after update
## OR ##
service mysqld start ## use restart after update

chkconfig --levels 235 mysqld on


 

6. MySQL Secure Installation



/usr/bin/mysql_secure_installation


 

7. Connect to MySQL database (localhost) with password



mysql -u root -p

## OR ##
mysql -h localhost -u root -p


 

8. Create Database, Create MySQL User and Enable Remote Connections to MySQL Database



按 Ctrl+C 复制代码

## CREATE DATABASE ## mysql> CREATE DATABASE webdb; ## CREATE USER ## mysql> CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123'; ## GRANT PERMISSIONS ## mysql> GRANT ALL ON webdb.* TO 'webdb_user'@'10.0.15.25'; ## FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES ## mysql> FLUSH PRIVILEGES;

按 Ctrl+C 复制代码