mysql5.7.20+初始化_MySQL-5.7.20 安装配置

找到类似如下：

A temporary password is generated for root@localhost: x8Ka2oY:D48v

其中“ x8Ka2oY:D48v” 就是初始密码。

启动mysql

service mysqld start

登陆mysql

mysql -uroot -p

在Enter password: 中输入初始密码 然后回车

执行sql修改密码

mysql>set password=password('test2018');

mysql>flush privileges;

mysql>exit;

重启mysql

service mysqld restart

7)修改/etc/my.cnf配置文件

vim /etc/my.cnf

替换内容如下：

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

symbolic-links=0

default-time-zone = '+8:00'

lower_case_table_names=1

log_bin_trust_function_creators=1

key_buffer_size = 384M

max_allowed_packet = 50M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

skip-name-resolve

user = mysql

log-bin=mysql-bin

server-id = 1

character_set_server = utf8

[mysqldump]

quick

max_allowed_packet = 50M

[mysql]

no-auto-rehash

default-character-set = utf8

[myisamchk]

key_buffer_size = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

[client]

default-character-set = utf8

重启mysql service mysqld restart 完成。

8)mysql服务的启动/重启/停止

service mysqld start # 启动服务

service mysqld restart # 重启服务

service mysqld stop # 停止服务

9)更改一些编码

mysql>use mysql

mysql>show variables like 'character%';

mysql>SET character_set_database = utf8;

10)mysql远程授权

mysql> grant all privileges on . to 'root'@'%' identified by 'test2018';

安装完毕！

11)数据库初始化

登录：

mysql -u root -ptest2018

创建数据库：

create database test2018 default charset=utf8;

退出：exit;

初始化数据：

mysql -uroot -ptest2018 --default-character-set=utf8 mastersp< /home/test2018.sql