linux版本suse连接mysql命令_Mysql 5.7安装说明（Linux suse11）

Mysql 5.7安装说明(Linux suse11)

Mysql 5.7安装说明(Linux suse11)

一、环境准备

安装环境:SUSE Linux Enterprise Server 11 (x86_64)

安装包：mysql-5.7.25-1.sles11.x86_64.rpm-bundle.tar

二、安装步骤

mysql下载地址：https://downloads.mysql.com/archives/community/

# mkdir software

使用xftp上传mysql-5.7.25-1.sles11.x86_64.rpm-bundle.tar到指定目录下

#tar xvf mysql-5.7.25-1.sles11.x86_64.rpm-bundle.tar

解压后如图所示:

common,libs,client,server,devel,embedded,embeded-devel

service mysql start

service mysql status

#grep ‘temporary password’ /var/log/mysql/mysqld.log

#mysql –u root –p

mysql>ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘[email protected]’;

(1)加入到系统服务

#chkconfig –add mysql

(2)随系统自动启动

#chkconfig mysql on

三、通过Navicat for MySQL远程连接

正常成功连接如图所示：

当出现报错mysql 1130时，为用户权限问题，解决方法如下：

权限设置语法：GRANT ALL PRIVILEGES ON . TO ‘用户名’@’%’ IDENTIFIED BY ‘用户密码’ WITH GRANT OPTION;

执行命令：

#mysql -u root -p

授权：

mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘[email protected]’ WITH GRANT OPTION;

刷新一下权限:

mysql>flush privileges;

可不用重启服务

Mysql 5.7安装说明(Linux suse11)相关教程