deepin mysql客户端_deepin 安装mysql

/wwwRoot/mysql/wwwRoot/mysql官网 https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

安装资料

shell> apt-cache search libaio # search for info

shell> apt-get install libaio1 # install library

shell> groupadd mysql

shell> useradd -r -g mysql -s /bin/false mysql

shell> cd /usr/local

shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz

shell> ln -s full-path-to-mysql-VERSION-OS mysql

shell> cd mysql

shell> mkdir mysql-files

shell> chown mysql:mysql mysql-files

shell> chmod 750 mysql-files

shell> bin/mysqld --initialize --user=mysql

shell> bin/mysql_ssl_rsa_setup

shell> bin/mysqld_safe --user=mysql &

# Next command is optional

shell> cp support-files/mysql.server /etc/init.d/mysql.server

错误1：

5.7.20# bin/mysqld --initialize --user=mysql

2017-12-17T01:20:52.448395Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-12-17T01:20:53.007185Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-12-17T01:20:53.057580Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-12-17T01:20:53.122093Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8637a948-e2c8-11e7-9675-000c2987d513.

2017-12-17T01:20:53.124177Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-12-17T01:20:53.124904Z 1 [Note] A temporary password is generated for root@localhost: g9p+HawiV/s#

2017-12-17T01:20:53.127760Z 1 [ERROR] 1 Can't create/write to file '/media/shaoyang/6924c011-8204-42a3-9e3e-db9816f210ba/mysql-5.7.20/data/mysql/db.MYI' (Errcode: 13 - Permission denied)

2017-12-17T01:20:53.127945Z 0 [ERROR] Aborting

2017-12-17T01:20:53.230963Z 0 [ERROR] InnoDB: Cannot open '/media/shaoyang/6924c011-8204-42a3-9e3e-db9816f210ba/mysql-5.7.20/data/ib_buffer_pool.incomplete' for writing: Permission denied

是因为没有配置文件 (添加配置 文件即可)

mkdir /wwwRoot/mysql

chowm -R mysql:mysql /wwwRoot/mysql

[client]

#客户端设置，即客户端默认的连接参数

#port = 3306

#默认连接端口

socket = /wwwRoot/mysql/mysql.sock

#用于本地连接的socket套接字

[mysqld]

datadir=/wwwRoot/mysql

socket=/wwwRoot/mysql/mysql.sock

user=mysql

log-error =/wwwRoot/mysql/error.log

pid-file=/wwwRoot/mysql/mysqld.pid

#skip-grant-tables=true

# Disabling symbolic-links is recommended to prevent assorted security risks

#symbolic-links=0

[mysqld_safe]

log-error=/wwwRoot/mysql/mysqld.log

pid-file=/wwwRoot/mysql/mysqld.pid

mysql 默认给了给临时密码

cat /wwwRoot/mysql/error.log

[Note] A temporary password is generated for root@localhost: =cQ/tj)!)3y5

用 =cQ/tj)!)3y5 用这个临时密码登录修改密码

set password for root@localhost = password('123456');

如果找不到临时密码

就启动 不需要密码登录

[mysqld]

datadir=/wwwRoot/mysql

skip-grant-tables=true

启动后 mysql -h 127.0.0.1 直接登录

修改密码 set password for root@localhost = password('123456');

如果报错：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

执行 ： flush privileges ;

在修改密码

support-files/mysql.server start 启动数据库