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

最新推荐文章于 2024-12-31 15:28:15 发布

boat824109722

最新推荐文章于 2024-12-31 15:28:15 发布

阅读量1.8k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/weixin_41279060/article/details/78798913

4 篇文章

订阅专栏

本文详细介绍MySQL 5.6版本在Linux环境下的安装步骤、字符集配置、用户授权及数据库创建等核心操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;