Linux centos安装mysql（解压手动安装）

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Linux centos安装mysql（解压手动安装），小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5419字，纯文字阅读大概需要8分钟。

内容图文

/usr/local

[root@localhost local]# chown -R mysql:mysql mysql/

[root@localhost mysql]# ll

total 56

drwxr-xr-x.  2 mysql mysql  4096 Jun 26 01:42 bin

-rw-r--r--.  1 mysql mysql 17987 Jun 26 01:42 COPYING

drwxr-xr-x.  5 mysql mysql  4096 Jun 26 04:40 data

drwxr-xr-x.  2 mysql mysql  4096 Jun 26 01:42 docs

drwxr-xr-x.  3 mysql mysql  4096 Jun 26 01:42 include

drwxr-xr-x.  5 mysql mysql  4096 Jun 26 01:43 lib

drwxr-xr-x.  4 mysql mysql  4096 Jun 26 01:42 man

-rw-r--r--.  1 mysql mysql  2478 Jun 26 01:39 README

drwxr-xr-x. 28 mysql mysql  4096 Jun 26 01:42 share

drwxr-xr-x.  2 mysql mysql  4096 Jun 26 01:43 support-files

[root@localhost mysql]# 

[root@localhost mysql]# pwd

/usr/local/mysql

    5，初始化数据。

[root@localhost mysql]# ./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

[root@localhost mysql]#

    6，复制配制文件。

[root@localhost mysql]# cp -a ./support-files/my-default.cnf /etc/my.cnf

[root@localhost mysql]#

    7，将Mysql的服务脚本放到/etc/init.d/目录下。

[root@localhost mysql]# cp -a ./support-files/mysql.server /etc/init.d/mysqld

[root@localhost mysql]#

    8，启动服务。

[root@localhost mysql]# service mysqld restart   

Shutting down MySQL.. SUCCESS! 

Starting MySQL.. SUCCESS! 

[root@localhost mysql]# 

    9，查看初始密码，并登录mysql。

[root@localhost mysql]# cat /root/.mysql_secret 

# Password set for user ‘root@localhost‘ at 2016-06-26 02:48:47 

:jiDfmi%5kaK

[root@localhost mysql]# ./bin/mysql -uroot -p

Enter password: （此处输入上述密码）

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

Your MySQL connection id is 3

Server version: 5.7.13

Copyright (c) 2000, 2016, 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> 

mysql> status    （下面会有报错，提示需要修改密码后再执行命令）

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> 

    10，修改mysql登录密码。

[root@localhost mysql]# ./bin/mysqladmin -uroot -p password

Enter password: （输入上述老密码）

New password: 

Confirm new password: 

Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

[root@localhost mysql]# 

    11，使用新密码即可登录mysql。

[root@localhost mysql]# ./bin/mysql -uroot -p

Enter password: （新密码）

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

Your MySQL connection id is 8

Server version: 5.7.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> select version();

+-----------+

| version() |

+-----------+

| 5.7.13    |

+-----------+

1 row in set (0.01 sec)

mysql> 

    12，至此mysql安装完成。

---

报错解决：

    1，

[root@localhost mysql-5.7.13]# ./bin/mysql_install_db --user=mysql

2016-06-26 02:47:09 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize

2016-06-26 02:47:09 [ERROR]   The data directory needs to be specified.

    解决：需要新建data目录，指定安装目录(在非默认目录时需要指定，默认路径：/usr/local/mysql，同时需要指定./support-files/mysql.server中的basedir和datadir为相应路径)。

[root@localhost mysql-5.7.13]# ./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.7.13/ --datadir=/usr/local/mysql-5.7.13/data/

2016-06-26 02:48:47 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize

2016-06-26 02:49:19 [WARNING] The bootstrap log isn‘t empty:

2016-06-26 02:49:19 [WARNING] 2016-06-26T09:48:50.798592Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead

2016-06-26T09:48:50.898732Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)

2016-06-26T09:48:50.898778Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)

    以上报错均因未在mysql.server中指定自定义的路径。

    2，启动mysql服务不成功。

[root@localhost ~]# /etc/init.d/mysqld start

/etc/init.d/mysqld: line 256: my_print_defaults: command not found

Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)

    解决：原来默认路径是/usr/local/mysql目录，这里存放目录是/usr/local/mysql-5.7.13。

    将mysql-5.7.13改为mysql再启动，发现如下错误：

 ERROR! MySQL server PID file could not be found!

    确认当前目录所有者为root，改为mysql：

[root@localhost local]# chown -R mysql:mysql mysql/    

[root@localhost local]# /etc/init.d/mysqld restart

 ERROR! MySQL server PID file could not be found!

Starting MySQL....... SUCCESS! 

        3,登录不成功，是因为服务没启动。

[root@localhost mysql-5.7.13]# cat /root/.mysql_secret 

# Password set for user ‘root@localhost‘ at 2016-06-26 02:48:47 

:jiDfmi%5kaK

[root@localhost mysql-5.7.13]# ./bin/mysql -uroot -p

Enter password: 

ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)

    解决：上面第2个问题解决后，此问题消失(需要将mysqld服务启动)。

---

参考：http://www.cnblogs.com/azhw/p/5143232.html

Linux centos安装mysql（解压手动安装）

标签：mysql

本文系统来源：http://chidongting.blog.51cto.com/1903900/1793053

内容总结

以上是互联网集市为您收集整理的Linux centos安装mysql（解压手动安装）全部内容，希望文章能够帮你解决Linux centos安装mysql（解压手动安装）所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---