(1)卸载linux自带的mysql
查看:rpm -qa | grep mysql
卸载:rpm -e --nodeps mysql-libs-5.1.66-2.el6_3.x86_64
查看:rpm -qa | grep mysql
(2)通过yum方式安装mysql
yum install -y mysql-server
(3)启动mysql服务
service mysqld start
可以验证一下: ps -ef |grep mysql
(4)设置root用户的密码
/usr/bin/mysqladmin -u root password '123'
(5)设置开机启动
查看是否开机启动:
chkconfig mysqld --list
设置开机启动:
chkconfig mysqld on
(6)登录mysql
mysql -u root -p
显示所有数据库:show databases;
使用某个数据:use database_name
显示所有的表:show tables;
(7)设置相关的mysql权限(相关信息是存储在mysql数据库中user表)
查看相关权限:
select user,host,password from user;
授权:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option
删除其它授权:
delete from user where host="bigdata-training01.huadian.com"
刷新授权:
flush privileges
(8)重启mysql服务
(9)安装成功的标准
在Windows Navicat能够远程连上mysql