MYSQL安装、编码设置、授权和数据库创建

MYSQL安装、编码设置、授权和数据库创建

MYSQL安装

MySQL-client-5.6.20-1.el6.x86_64.rpm

MySQL-server-5.6.20-1.el6.x86_64.rpm

MySQL-devel-5.6.20-1.el6.x86_64.rpm

scp root@192.168.100.63:/credit/MySQL-client-5.6.20-1.el6.x86_64.rpm /opt/

scp root@192.168.100.63:/credit/MySQL-server-5.6.20-1.el6.x86_64.rpm /opt/

scp root@192.168.100.63:/credit/MySQL-devel-5.6.20-1.el6.x86_64.rpm /opt/

cd /opt

rpm -ivh MySQL-server-5.6.20-1.el6.x86_64.rpm

rpm -ivh MySQL-client-5.6.20-1.el6.x86_64.rpm

rpm -ivh MySQL-devel-5.6.20-1.el6.x86_64.rpm

如果安装有lib冲突，解决冲突，看提示日志解决冲突，一般把冲突的包全删了

yum -y remove mariadb-libs-*

看提示

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !

You will find that password in '/root/.mysql_secret'.

初始密码在/root/.mysql_secret

cat /root/.mysql_secret

即可看到

service mysql start

mysql -uroot -p初始化密码

更改密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

配置mysql的字符编码

cd /usr/share/mysql/

cp my-default.cnf my.cnf

做如下更改

vi my.cnf

[client]

default-character-set=utf8

[mysqld]

character-set-server=utf8

cp my.cnf /etc/

service mysql restart

mysql -uroot -p123456

SET character_set_client = utf8;

SET character_set_connection = utf8;

SET character_set_database = utf8;

SET character_set_results = utf8;

SET character_set_server = utf8;

SHOW VARIABLES LIKE 'character%';#所有的都是utf-8

创建用户和授权

CREATE USER 'xdwp'@'%' IDENTIFIED BY 'Aa123456q1w2e3r4t5';

GRANT ALL ON *.* TO 'xdwp'@'%';

flush privileges;

创建数据库

CREATE DATABASE xdrec DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;