Linux安装配置mysql

-- 检查是否安装mysql，如果已安装，以下都不要安装了
rpm -qa | grep mysql-server

sudo yum -y install mysql-server

sudo vi /etc/my.cnf

在[mysqld]节点下修改default-character-set的编码为utf8
default-character-set=utf8

-- 开机启动配置
sudo chkconfig mysqld on

-- 查看启动状态，第二个到第五个启用状态的话代表成功
sudo chkconfig --list mysql

-- 启动mysql
sudo service mysqld start

mysql> select user,host from mysql.user;

-- 删除匿名用户
mysql> delete from mysql.user where user='';

mysql> flush privileges;

-- 开启防火墙3306端口
sudo vi /etc/sysconfig/iptables

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

-- 重启防火墙
sudo service iptables restart

-- root用户登录
mysql -u root

-- mysql -u root -p password

mysql> select user, host, password from mysql.user;

-- 修改root密码
mysql> set password for root@localhost=password(''123456');

exit;

mysql -u root -p;

-- 删除匿名用户
mysql> select user, host from mysql.user;
mysql> delete from mysql.user where user='';

mysql> select user, host from mysql.user;

-- 刷新权限
mysql> flush privileges;

mysql> insert into mysql.user(Host, User, Password) values('localhost', 'yourname', password('yourpassword'));

mysql> flush privileges;

mysql> create database 'new_dbname' default character set utf8 COLLATE utf8_general_ci;

-- 本地用户赋予所有权限
mysql> grant all privileges on new_dbname.* to yourname@localhost identified by 'yourpassword'

-- 给帐号开通外网所有权限
mysql> grant all privileges on new_dbname.* to yourname@'%' identified by 'yourpassword'

-- 根据实际情况开通权限
mysql> grant select,insert,updaate on new_dbname.* to yourname@'192.168.26.130' identified by 'yourpassword'

mysql> flush privileges;

mysql> exit


-- 以下是启动，停用、重启mysql的服务
sudo service mysqld start

sudo service mysqld stop

sudo service mysqld restart