下载版本:mysql5.6.40,red-hat 64位 mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
1,解压 | tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz |
2,添加用户组 | groupadd mysql useradd -g mysql mysql |
cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql |
3,安装 |
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
|
4,添加到系统服务 | 在/usr/lib/systemd/system目录下增加mysql.service,内容如下 [Unit] Description=Mysql After=syslog.target network.target remote-fs.target nss-lookup.target [Service] Type=forking PIDFile=/usr/local/mysql/data/XXX.pid ExecStart=/usr/local/mysql/support-files/mysql.server start ExecReload=/bin/kill -s HUP $MAINPID ExecStop=/bin/kill -s QUIT $MAINPID PrivateTmp=false [Install] 重新载入单元,扫描新的或有变化的单元,使刚刚添加的mysql.service生效 systemctl daemon-reload 此后,则可通过如下命令操作Mysql systemctl enable mysql
systemctl start mysql
systemctl stop mysql
systemctl restart mysql
|
5,设置环境变量 |
#加入环境变量,编辑 /etc/profile,这样可以在任何地方用mysql命令了
export
PATH=$PATH:
/usr/local/mysql//bin
<br>
source
/etc/profile
|
6,启动mysql | systemctl enable mysql
systemctl start mysql
systemctl stop mysql
systemctl restart mysql |
7,开启远程连接 | GRANT ALL PRIVILEGES ON *.* TO ‘root’@'%’ IDENTIFIED BY ‘youpassword’ WITH GRANT OPTION;flush privileges; |
问题1:
root@abc~]# mysql -u root
-bash: mysql: command not found
-bash: mysql: command not found
原因:这是由于系统默认会查找/usr/bin下的命令,如果这个命令不在这个目录下,当然会找不到命令,我们需要做的就是映射一个链接到/usr/bin目录下,相当于建立一个链接文件。
首先得知道mysql命令或mysqladmin命令的完整路径,比如mysql的路径是:/usr/local/mysql/bin/mysql,我们则可以这样执行命令:
首先得知道mysql命令或mysqladmin命令的完整路径,比如mysql的路径是:/usr/local/mysql/bin/mysql,我们则可以这样执行命令:
ln -s /usr/local/mysql/bin/mysql /usr/bin
问题2:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
问题3:自己在mysql命令行下:
mysql>source /Users/robot/Downloads/sql_table.sql