centos 安装mysql5.6.13

linux11年前 (2015)发布 admin

378 0 0

安装参考地址
http://www.jb51.net/article/47094.htm
下载mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.13.tar.gz/from/http://cdn.mysql.com/
安装cmake
yum install cmake

编译命令
time cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql56 -DMYSQL_DATADIR=/data56 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR==/data56/mysql.sock -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

出错
Make Error at /usr/share/cmake/Modules/TestBigEndian.cmake:44CMake Error at /usr/share/cmake/Modules/TestBigEndian.cmake:44 (message):

解决方式
删掉CMakeCache.txt 即可
出错
CMake Error at cmake/readline.cmake:85
解决

yum -y install ncurses-devel
删掉CMakeCache.txt
出错
Warning: Bison executable not found in PATH

解决方法：

[root@vm6-web1 mysql-5.5.28]# yum install bison
出错
bash: mysql: command not found
解决
ln -s /usr/local/mysql56/bin/mysql /usr/bin
出错
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘=/data56/mysql.sock’ (2)
失败，删除完全删除mysql
使用系统添加删除软件，删除，，好像提示了一个安装软件，，，，，给予root授权后，就自己好了。莫名其妙

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.6.23    |
+-----------+
1 row in set (0.00 sec)

mysql 密码登录
mysql -u root -p

# linux