centos下安装mysql

mysql –uroot –p123456 -Dtest <./ss.sql

 

安装

rpm -qa | grep mysql 

yum install mysql 

yum install mysql-server

 

配置查看端口 

vi /etc/my.conf

port=xxx

show variables like 'port';

 

服务端口

前面是mysql自己的端口，这里是centos给予mysql服务的端口，如果不用默认的要修改

setenforce 0

修改/etc/service端口

 

启动查看命令

/etc/init.d/mysqld stop start restart

netstat -l | grep mysql

mysql -u root -p

安全模式启动

mysql_safe --skip-grant-tables &

 

权限问题

1.改密码

set password for  root@localhost=password(‘123456789’);

FLUSH PRIVILEGES 千万记得

 

2.插入用户

GRANT ALL PRIVILEGES ON cdh_amon.* TO 'cdh_amon'@localhost WITH GRANT OPTION

 

GRANT ALL PRIVILEGES ON cdh_amon.* TO 'cdh_amon'@localhost IDENTIFIED BY 'cdh_amon' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON cdh_amon.* TO 'cdh_amon'@'%' IDENTIFIED BY 'cdh_amon' WITH GRANT OPTION;

FLUSH PRIVILEGES;

 

测试

select * from mysql.user

mysql -h 127.0.0.1 -u root -p -P 3306 

 

 

远程机器无法连接的问题

1.iptables

2.user mysql; update user set host = '%' where user = 'root' 设定远程可以访问

 

修改表ip权限问题

grant alter on yqcp.portalconfig to root@'%';