MySQL5.6 installation tutorial under Centos6.5-Mysql Tutorial-php.cn

MySQL5.6 installation tutorial under Centos6.5

黄舟

Release： 2017-03-17 13:46:13

Original

1466 people have browsed it

This article mainly introduces the Centos 6.5Installation MySQL 5.6 tutorial, which is very good and has reference value. Friends who need it can refer to it

1 .Download the corresponding RPM package of Linux

2. Unzip the tar package

tar -xvf MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar

Copy after login

3. Install MySQL

rpm -ivh MySQL-server-5.6.33-1.el6.x86_64.rpm 
rpm -ivh MySQL-client-5.6.33-1.el6.x86_64.rpm 
rpm -ivh MySQL-devel-5.6.33-1.el6.x86_64.rpm

Copy after login

If it appears:

error: Failed dependencies:
    libaio.so.1()(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64
    libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64
    libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

Copy after login

Download libaio

yum install libaio

Copy after login

If it appears:

error: Failed dependencies:
    libnuma.so.1()(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64
    libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64
    libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64

Copy after login

Download numactl

yum install numactl

Copy after login

4. Initialize MySQL and set the password

/usr/bin/mysql_install_db
service mysql start

Copy after login

If the startup fails, it may be data The directory where the block is located has no permissions

cat /root/.mysql_secret #查看root账号密码
mysql> SET PASSWORD = PASSWORD(&#39;123456&#39;);
mysql> exit

Copy after login

If the .mysql_secret file does not exist, first stop MySQL and enter Safe modeSet password

service mysql stop
mysqld_safe --skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user=&#39;root&#39;;
mysql> FLUSH PRIVILEGES;

Copy after login

5. Allow remote login

mysql> use mysql;
mysql> select host,user,password from user;
mysql> update user set host=&#39;%&#39; where user=&#39;root&#39; and host=&#39;localhost&#39;;
mysql> flush privileges;
mysql> exit

Copy after login

6. Set up auto-start at boot

chkconfig mysql on
chkconfig --list | grep mysql
mysql      0:off  1:off  2:on  3:on  4:on  5:on  6:off

Copy after login

7. The default installation location of MySQL

/var/lib/mysql/        #数据库目录
/usr/share/mysql       #配置文件目录
/usr/bin           #相关命令目录
/etc/init.d/mysql       #启动脚本

Copy after login

8. Common commands

1. Use client tools to connect to the database

mysql -u root -p

Copy after login

2. Check which databases are included in the MySQL server

mysql>SHOW DATABASES;

Copy after login

3. Check the data table information in the database

mysql>SHOW TABLES;

Copy after login

4. Switch databases

mysql>USE mysql;

Copy after login

5. Create a new database

mysql>CREATE DATABASE 数据库名字;

Copy after login

6.Create a new data table

mysql>CREATE TABLE 表名 (字段定义)

Copy after login

7.Delete a data table

mysql>DROP TABLE 数据库名.表名;

Copy after login

8.Delete a database

mysql>DROP DATABASE 数据库名

Copy after login

9. Back up the entire database

mysqldump -u root -p auth > mysql-auth.sql

Copy after login

10. Back up the user table in the database MYSQL

mysqldump -u root -p mysql user > mysql.host-user.sql

Copy after login

11. Back up all databases in the MYSQL server

mysqldump -u root -p -all-databases > mysql-all.sql

Copy after login

12. Restore the database

mysql -u root -p [数据库名]< mysql-all.sql

Copy after login

13. Grant user permissions

GRANT 权限列表 ON 数据库名.表名 TO 用户名@来源地址 [IDENTIFIED BY &#39;密码&#39;]
GRANT SELECT ON mysql.user TO daxiong@&#39;localhost&#39; IDENTIFIED BY&#39;123456&#39;;

Copy after login

The above is the detailed content of MySQL5.6 installation tutorial under Centos6.5. For more information, please follow other related articles on the PHP Chinese website!