MySQL5.6 installation tutorial under Centos6.5

This article mainly introduces the Centos 6.5InstallationMySQL 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

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

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

Download libaio

yum install libaio

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

Download numactl

yum install numactl

4. Initialize MySQL and set the password

/usr/bin/mysql_install_db
service mysql start

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('123456');
mysql> exit

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='root';
mysql> FLUSH PRIVILEGES;

5. Allow remote login

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

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

7. The default installation location of MySQL

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

8. Common commands

1. Use client tools to connect to the database

mysql -u root -p

2. Check which databases are included in the MySQL server

mysql>SHOW DATABASES;

3. Check the data table information in the database

mysql>SHOW TABLES;

4. Switch databases

mysql>USE mysql;

5. Create a new database

mysql>CREATE DATABASE 数据库名字;

6.Create a new data table

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

7.Delete a data table

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

8.Delete a database

mysql>DROP DATABASE 数据库名

9. Back up the entire database

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

10. Back up the user table in the database MYSQL

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

11. Back up all databases in the MYSQL server

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

12. Restore the database

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

13. Grant user permissions

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

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!