1. Download
: Http://dev.mysql.com/downloads/mysql/5.6.html#downloads
Download version: I choose here 5.6.33, General edition, Linux under 64-bit
You can also directly copy the 64-bit, download by command: wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
2. Decompression
1234 |
#解压 tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64. tar .gz #复制解压后的mysql目录 cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql |
3. Adding user groups and users
1234 |
#添加用户组 groupadd mysql #添加用户mysql 到用户组mysql useradd -g mysql mysql |
4. Installation
123456789101112131415161718192021222324252627282930 |
cd
/usr/local/mysql/
<br>
mkdir
.
/data/mysql
chown -R mysql:mysql ./
.
/scripts/mysql_install_db
--user=mysql --datadir=
/usr/local/mysql/data/mysql
cp
support-files
/mysql
.server
/etc/init
.d
/mysqld
chmod
755
/etc/init
.d
/mysqld
cp
support-files
/my-default
.cnf
/etc/my
.cnf
#修改启动脚本
vi
/etc/init
.d
/mysqld
#修改项:
basedir=
/usr/local/mysql/
datadir=
/usr/local/mysql/data/mysql
#启动服务
service mysqld start
#测试连接
.
/mysql/bin/mysql
-uroot
#加入环境变量,编辑 /etc/profile,这样可以在任何地方用mysql命令了
export
PATH=$PATH:
/usr/local/mysql//bin
<br>
source
/etc/profile #启动mysql
service mysqld start
#关闭mysql
service mysqld stop
#查看运行状态
service mysqld status
|
5. Error
5.1 SQLyog 1130 error when connecting, due to no user rights issue for remote connection
Resolution 1: Change the ' MySQL ' database ' user ' table ' host ' entry from ' localhost ' to '% '.
Resolution 2: Direct authorization
GRANT all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;
5.2 Some errors during installation
-bash:./scripts/mysql_install_db:/usr/bin/perl:bad Interpreter: No file or directory
FIX: yum-y Install Perl perl-devel
Installing MySQL system Tables..../bin/mysqld:error while loading shared libraries:libaio.so.1:cannot open shared objec T file:no such file or directory
Solution: Yum-y Install Libaio-devel
6. Other
6.1 Configuring Environment variables
VI +/etc/profile
Export Path=....:/usr/local/mysql/bin
MySQL installation under Linux