mysql安装与配置(linux)

mysql安装和配置
--------------------------------------
先检查linux有无自带的数据库，有就先卸载
查询有无库：rpm -qa | grep -i mysql
卸载系统自带的mysql：rpm -ev 包名 --nodeps
切换到root用户在softwars目录下安装mysql服务：rpm -ivh mysql包名(MySQL-server-5.6.24-1.el6.x86_64.rpm)
同理安装mysql客户端：rpm -ivh mysql客户端包名
然后查看mysql的初始密码：cat /root/.mysql_secret
启动mysql服务：service mysql start
设置成开机启动：chkconfig mysql on
登录mysql：chkconfig mysql on
修改密码为123456：SET PASSWORD=PASSWORD('123456');
授权所有电脑的root用户可以访问数据库：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
设置成修改生效：flush privileges;

例如，你想user使用password从任何主机连接到mysql服务器的话。 
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'IDENTIFIED BY 'password' WITH GRANT OPTION; 
如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器，并使用password作为密码 
GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.3'IDENTIFIED BY 'password' WITH GRANT OPTION;
---------------------------------------------------
mysql的sql语句：
show databases;
use mysql;
show tables;
select User,Host,Password from user ;
update user set Host='%' where User='root' and Host='localhost';
delete from user where User='root' and Host='hadoop-ding111';
delete from user where User='root' and Host='127.0.0.1';
delete from user where User='root' and Host='::1';
select User,Host,Password from user ;
刷洗flush privileges ;
exit；
退出mysql：\q
------------------------------

转载于:https://my.oschina.net/u/3452107/blog/1797382