mysql安裝

MySQL安裝

MySQL的幾個常用安裝包：rpm（無法定義安裝路徑跟二進制差別）、源碼(Cmake)、二進制免編譯(編譯過好的儲存在一個目錄下在打包壓縮)沒有特殊要求可以使用這種方法

cd /usr/local/src

tar zxvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz 

mv mysql-5.6.35-linux-glibc2.5-x86_64 /usr/local/mysql 

cd /usr/local/mysql 

useradd mysql

mkdir /data/ 存放mysql資料

./scripts/mysql_install_db --user=mysql --datadir=/data/mysql 初始化

cp support-files/my-default.cnf /etc/my.cnf 

cp support-files/mysql.server /etc/init.d/mysqld

vi /etc/init.d/mysqld

定義basedir和datadir

basedir=/usr/local/mysql

datadir=/data/mysql

[root@localhost mysql]# service mysqld start

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name 

tcp 0 0 127.0.0.1:25 0.0.0.0: LISTEN 1788/master 

tcp 0 0 0.0.0.0:22 0.0.0.0: LISTEN 1111/sshd 

tcp6 0 0 ::1:25 ::: LISTEN 1788/master 

tcp6 0 0 :::3306 ::: LISTEN 20133/mysqld

如果沒有/etc/init.d/啟動檔案可采用的啟動方式如下圖：

停止的方式：killall mysqld

killall 先停止目前的寫讀操作，把還沒有寫入磁盤的資料寫入磁盤，在殺死程序

問題！！

[root@lsx-001 mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql

FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:

Data::Dumper

解決辦法安裝

[root@lsx-02 mysql]# yum install -y autoconf

[root@lsx-001 mysql]# yum list|grep -i perl |grep -i dumper

perl-Data-Dumper.x86_64 2.145-3.el7 base

2.

Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

[root@lsx-02 mysql]# yum list |grep 'libaio'

[root@lsx-02 mysql]# yum install -y libaio-devel.x86_64

3.啟動報錯Starting MySQL.Logging to '/data/mysql/localhost.localdomain.err'.

./usr/local/mysql/bin/mysqld_safe: line 178: 2830 Killed nohup /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/localhost.localdomain.err --pid-file=/data/mysql/localhost.localdomain.pid < /dev/null > /dev/null 2>&1

ERROR! The server quit without updating PID file (/data/mysql/localhost.localdomain.pid).

解決辦法：

1.cd /usr/local/mysql（進入mysql安裝目錄）

2.chown -R mysql.mysql .

3.su - mysql

4.cd /usr/local/mysql

5.scripts/mysql_install_db

4.登入mysql

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

less /etc/my.cnf|grep sock

#socket = .....

vi /etc/my.cnf

socket = /tmp/mysql.sock  #添加該行

重新開機

5.啟動錯誤後面提示什麼檔案沒找到ERROR! MySQL server PID file could not be found!

就建立一個。比如：

touch /data/mysql/localhost.localdomain.pid

本文轉自 蝦米的春天 51CTO部落格，原文連結：http://blog.51cto.com/lsxme/2050912，如需轉載請自行聯系原作者