1 # yum -y install mysql-server mysql mysql-devmysql
2 启动mysql # service mysqld startsql
3 为root用户配置一个密码 #mysqladmin -u root password '密码'数据库
4 用root用户登陆 #mysql -u root -p vim
5 输入密码登陆到mysql 编码
6 看一下数据库 mysql> show databases;spa
7 此时数据库已经安装完成了，可是此时只有本机能访问，局域网内其余用户没法访问到.net
8 切入mysql数据库 mysql> use mysql;rest
9 查询用户表信息 mysql> select host,user,password from user;server
10 删除无用的用户 delete from user where password='';blog
11 再次查询 此时只有一个用户了 绑定机器名是localhost 也就是只有本机下能够访问到
12 将localhost 修改成% mysql> update user set host='%';
13 修改后须要刷新权限 mysql> flush privileges;
此时关闭防火墙后局域网内其余用户也能够访问了
设置mysql编码为中文
cd /etc/
vim f
打开/etc/f修改配置文件：
[root@Web_Mysql ~]# vim /etc/f
在[client]下添加
default-character-set=utf8
在[mysqld]下添加
default-character-set=utf8
：wq #保存
重启mysql
service mysqld restart
[root@Web_Mysql ~]# mysql -u root -p
Enter password: (输入密码)
mysql> show variables like 'character%';
+-----------------------------------------+------------------------------------------+
| Variable_name| Value|
+-----------------------------------------+------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary|
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
OK;
==========================================================
wget/mysql-community-release-el7-5.noarch.rpm
mysql-community-release-el7-5.noarch.rpm
ls-1/etc/yum.repos.d/mysql-community*
yuminstallmysql-server
==============================
hkconfig mysqld on mysql 服务开机自启
chkconfig iptables off 永久关闭防火墙
