mysql5.7安装1

查看mysql：rpm -qa |grep -i mysql

查看linux版本：cat /etc/system-release

下载mysql--5.7.18的tar包

查看mysql :rpm -aq|grep i mysql

sudo chmod -R  755 /tpad/yhya/*

userdel mysql                                           # 删除用户

# groupdel mysql                                          # 删除用户组名

# mkdir /home/mysql                                       # 在home文件夹下创建文件夹mysql

# mkdir /home/mysql/data                                  # 在mysql文件夹下创建文件夹data  

# groupadd mysql                                          # 创建一个名为mysql的用户组       




# cd /home/mysql

# ./support-files/mysql.server start

Starting MySQL.. OK!

# useradd -g mysql -d /home/mysql mysql                   # 在用户组下创建用户

# tar -xzvf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz              # 解压文件

# cd mysql-5.7.13-linux-glibc2.5-x86_64                            # 进入

# mv * /home/mysql                                                # 移动到之前我创建的mysql文件夹下




mysql5.7新特性：由上面可以看出， mysql_install_db 已经不再推荐使用了，建议改成 mysqld --initialize 完成实例初始化。

1 2 3 4 5

# ./bin/mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize # ./mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). [ERROR] --initialize specified but the data directory has files in it. Aborting. 2016-04-08T01:46:53.155879Z 0 [ERROR] Aborting

cd /home/mysql/data                        # 进入安装目录下的data目录

# rm -fr *                                   # 清空数据

# cd /home/mysql      

# ./bin/mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-08T01:47:59.945537Z 0

[Warning] InnoDB: New log files created, LSN=45790 2016-04-08T01:48:00.333528Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-04-08T01:48:00.434908Z 0

[Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ece26421-fd2b-11e5-a1e3-00163e001e5c. 2016-04-08T01:48:00.440125Z 0

[Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-04-08T01:48:00.440904Z 1

[Note] A temporary password is generated for root@localhost: **mjT,#x_5sW

# cd /home/mysql

# ./support-files/mysql.server start

Starting MySQL.. OK!

1 2 3 4 5 6 7 8 9

# vim support-files/mysql.server -------------------------- ... basedir=/home/mysql datadir=/home/mysql/data ... -------------------------- # ./support-files/mysql.server start start Starting MySQL.. OK!

# cd /home/mysql

# ./support-files/mysql.server start

Starting MySQL.. OK!

-------------------------------------------------------------------

后续所有的命令都用sudo启动；

------------------------------------------------------------

第二就是My.cnf 一般在etc目录下

----------------------------------------------------------

会提示某个pid找不到，只要杀掉就即可

----------------------------------------------------------

第三就是查看密码cat /var/log/mysql.log |grep password

---------------------------------------------------------------------

第四在bin目录下，点击mqsql -u root  -p

通过登录mysql系统，
# mysql -uroot -p
Enter password: 【输入原来的密码】
mysql>use mysql;
mysql> update user set password=passworD("test") where user='root';
mysql> flush privileges;
mysql> exit;     

------------------------------------------------

查看数据库版本 status;

----------------------------------------------------

出现错误

Native table 'performance_schema'.'session_variables' has the wrong structure

行操作：

1.输入：mysql_upgrade -uroot -p

2.重启mysql服务：mysql.service restart

然后就操作正常了。

---------------------------------------------------------------------------

创建数据库同其他

1.tar -xzvf    .....

2.建立 /home/mysql                                              /home/mysql/data

3.my.cnf   放在etc目录下；my.cnf可以改路径

4.不是root权限可以用   sudo  cp   /home/                  ***

----------------------------------------------

下载地址

https://dev.mysql.com/downloads/file/?id=469566