mysql5.7安装1

来源：互联网发布：电脑tv电视直播软件编辑：程序博客网时间：2024/05/17 22:15

查看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 完成实例初始化。

# ./bin/mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize
# ./mysqld --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize
[Warning] TIMESTAMPwithimplicitDEFAULTvalueisdeprecated. 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] TIMESTAMPwithimplicitDEFAULTvalueisdeprecated. 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: Creatingforeignkeyconstraintsystem tables. 2016-04-08T01:48:00.434908Z 0

[Warning] Noexisting UUID has been found, so we assume that thisisthefirsttime

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 tobe used.Table'mysql.gtid_executed'cannot be opened. 2016-04-08T01:48:00.440904Z 1

[Note] A temporarypasswordisgeneratedforroot@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

阅读全文

0 0