安装Linux版本Mysql步骤:
(1)打开官网下载Mysql(rpm版本)
(2)检查当前系统是否安装过mysql
rpm -qa|grep -i mysql
如果安装过会显示下图
(3)卸载mysql
1)停止mysql服务、删除之前安装的mysql
2)rpm -e --noscripts MySQL-client-5.6.24-1.el6.x86_64
rpm -e --noscripts MySQL-server-5.6.24-1.el6.x86_64
3)卸载后/etc/my.cnf不会删除,需要进行手工删除
rm
-rf
/etc/my
.cnf
(4)安装mysql
rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm (安装服务端)
rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm (安装客户端)
(5)查看安装时创建的Mysql用户和mysql组
cat /etc/passwd|grep mysql
cat /etc/group|grep mysql
(6)启动mysql
systemctl start mysql
查看mysql进程如上图,表面mysql安装成功,且启动成功
关闭mysql:systemctl stop mysql
重启mysql:systemctl restart mysql
(7)设置mysql密码(初次安装mysql的root用户没有密码)
/usr/bin/mysqladmin -u root password 123
(8)客户端连接服务端
注意:
(1)安装出现冲突:系统已经安装了其他版本的mysql-libs包和mysql数据库文件导致不兼容
执行:yum remove mysql-libs
(2)/usr/bin/mysqladmin -u root passwd 123 报权限错
mysqld --user=mysql --skip-grant-tables&
systemctl stop mysql
>mysqld_safe --skip-grant-tables &
输入 mysql -uroot -p 回车进入
>use mysql;
> update user set password=PASSWORD("123")where user="root";
更改密码为 123
> flush privileges; 更新权限
> quit 退出
修改mysql的配置文件
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
show variables like '%char%';
查看数据库字符集,服务端是latin1,需要修改成utf-8
修改/etc/my.cnf
添加
[client]
default-character-set=utf8
[mysqld]
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci
[mysql]
default-character-set=utf8
重启mysql
客户端连接mysql报错:Access denied for user 'root'@'localhost'或者@“ip”解决方法
(1)关闭防火墙
systemctl stop firewalld.service
(2)修改mysql库下的user表
use mysql;
update user set host = ’%’ where user = ’root’; //%可以换成ip
grant all privileges on *.* to 'root'@'%' identified by '123';
flush privileges;