mysql 5.6 文档_MySQL5.6安装文档

groupadd mysql

useradd -r -g mysql mysql

mkdir -p /kingsql/database/mysql/tmp/

mkdir -p /kingsql/database/mysql/log/

touch /kingsql/database/mysql/log/mysqld.log

[root@ogg02 ~]# cd /kingsql/database/mysql/

[root@ogg02 mysql]# pwd

/kingsql/database/mysql

[root@ogg02 mysql]# ls

log mysql5.6.40_kingsql.tar.gz tmp

[root@ogg02 mysql]# tar -zxvf mysql5.6.40_kingsql.tar.gz

[root@ogg02 mysql]# cd

[root@ogg02 ~]# chown mysql:mysql -R /kingsql

[root@ogg02 etc]# vi /etc/my.cnf

[client]

socket = /kingsql/database/mysql/tmp/mysql.sock

[mysqld_safe]

log-error=/kingsql/database/mysql/log/mysqld.log

pid-file=/kingsql/database/mysql/mysqld.pid

[mysqld]

basedir = /kingsql/database/mysql

datadir = /kingsql/database/mysql/data

port = 3306

socket = /kingsql/database/mysql/tmp/mysql.sock

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[root@ogg02 etc]# echo "export PATH=$PATH:/kingsql/database/mysql/bin" >> /etc/profile

[root@ogg02 etc]# source /etc/profile

[root@mysqldb ~]# /kingsql/database/mysql/scripts/mysql_install_db --basedir=/kingsql/database/mysql --datadir=/kingsql/database/mysql/data --user=mysql --defaults-file=/etc/my.cnf

[root@mysqldb ~]# mysqld_safe&

[root@mysqldb ~]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 5.6.40 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set password=password('oracle') where user='root';

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> quit

Bye

[root@mysqldb ~]# mysql -uroot

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root@mysqldb ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 12

Server version: 5.6.40 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>