Mysql安装
1、由于我是CentOs6.5的版本,直接用yum就可以了
yum install mysql-server
假如是CentOs7及以上的版本,默认数据库为mariadb,要先移除mariadb,然后再进行安装
yum remove mariadb-libs.x86_64 #版本号视具体版本而定
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm
yum install mysql-community-server
2、启动mysql
service mysqld start
3、登录mysql,我这密码默认为空
mysql -u root -p
若是centos7安装的社区版的话,可能初始密码不为空,那起始密码保存在/var/log/mysqld.log中,可通过如下命令查看
cat /var/log/mysqld.log |grep password
Mysql的一些基本操作
修改密码
进入mysql终端后输入
mysql> SET PASSWORD = PASSWORD(‘123456’); #将密码设置为123456
设置远程连接
1、先进入mysql终端 2、选择mysql库,并修改user表
mysql> use mysql;
mysql> update user set host = ‘%’ where user = ‘root’ and host=’localhost’;
3、刷新权限
mysql> flush privileges;
这时候应该就可以通过navicat等工具远程连接上了,假如还不行,试试关闭防火墙
新建用户
mysql> create user ‘kingkk‘@’%’ identified by ‘123456’;
create user 用户名@主机 identified by‘密码’
赋予权限
可以赋予的权限有 all / select / insert /delete / update . 处表示 库.表
mysql> grant all privileges on . to ‘kingkk‘@’%’ identified by ‘123456’ with grant option;
grant 权限 privileges on 库.表 to ‘用户名‘@’主机’ identified by ‘密码’ with grant option; 刷新权限
mysql> flush privileges;
移除权限
mysql> revoke all privileges on . from kingkk
revoke 权限 privileges on 库.表 from kingkk 刷新权限
mysql> flush privileges;