一、安装教程
https://jingyan.baidu.com/article/a378c9609eb652b3282830fd.html
注意:32为的系统安装32为的mysql,64位的系统安装64为的mysql
二、
一、查找以前是否安装有mysql,使用下面命令:
rpm -qa | grep mysql
如果显示有如下包则说cd明已安装mysql
MySQL-client-5.6.21-1.el6.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64
MySQL-devel-5.6.21-1.el6.x86_64
把冲突的包mysql-libs-5.1.73全部卸载
yum -y remove mysql-libs-5.1.73*
或者命令:
rpm -e MySQL-devel-5.6.21-1.el6.x86_64 --nodeps
删除老版本mysql的开发头文件和库
命令:
rm -rf /usr/lib/mysql
rm -rf /usr/include/mysql
注意:卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除,如果确定没用后就手工删除
命令:
rm -rf /etc/my.cnf
rm -rf /var/lib/mysql
二、mysql的下载安装之rpm安装法(有通过二进制压缩文件解压安装法,可自行百度)
可通过http://10.129.0.147/downloads/
或
http://dev.mysql.com/downloads/mysql/5.6.html#downloads
下载mysql文件进行安装
下载后放到linux服务器上,通过rz命令可上传文件
安装mysql的每个包
命令:
rpm -ivh MySQL-server-5.6.21-1.el6.x86_64.rpm
结果:
省略号.......
安装成功
命令:
rpm -ivh MySQL-client-5.6.21-1.el6.x86_64.rpm
安装成功
命令:
rpm -ivh MySQL-devel-5.6.21-1.el6.x86_64.rpm
安装成功
三、运行mysql
输入命令mysql
说明mysql未启动,执行service mysql start命令或者/etc/init.d/mysql start
启动成功
输入命令:
mysql -u root -p,出现Enter password:,直接回车进入mysql
如不能直接登录,退出此命令,输入cat /root/.mysql_secret查看生成的随机密码
再次执行mysql -u root -p,出现Enter password:,粘贴随机密码WeC9wshnoGrJSuBG,回车,进入mysql
设置mysql的密码为root123456命令:
set password = password(‘root123456’);
Mysql的登录格式如下:
mysql -u root -p
Enter password: 密码
四、各种设置
设为开机自启动
/etc/init.d/mysql start
设置完成后重启系统,使用netstat -nat命令可看到MySQL的3306端口
或通过命令查看是否在自启动服务中sbin/chkconfig --list
五、使用navicat链接mysql报错处理
1
.
赋予远程权限,命令:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新权限flush privileges;
重新使用navicat链接
2
.
很大原因是由于密码问题造成,执行命令:
1、停止mysql服务:“/etc/init.d/mysql stop”
2、以命令行参数启动mysql,不启动授权表:“mysqld_safe --user=mysql --skip-grant-tables --skip-networking &”
3、使用root用户无密码登录:“mysql -u root mysql”
4、进入mysql命令行,修改root用户密码“update user set password=password('新密码') where user='root';”
5、刷新权限:“flush privileges;”
6、退出mysql:“quit”
7、重启mysql:“/etc/init.d/mysql restart”
8、验证新密码是否可以登录
mysql -u root -p
Enter password: 输入新设的密码
再次通过navicat连接mysql
六、出现[root@vm-10-152-4-52 webapps]# mysql -u ecms -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory")
解决:
把sock软链接到目标路径。以笔者的问题为例,就是:
ln -s /run/mysqld/mysql.sock /tmp/mysql.sock
七、Linux安装mysql 在/etc下没有my.cnf 解决办法
进入 /usr/share/mysql
将my-medium.cnf 移动到etc 并且改名为my.cnf
八、查看软连接的位置
- 在Linux命令行界面输入命令:ls -al;
-
2、带有“->”符号的则为软连接,initrd.img为软连接的文件名,而->后面跟着的boot/initrd.img-3.13.0-32-geberic则为软连接文件的真实路径。
-
九、常规报错
1、Can't Change to Run as User 'Mysql'. Please Check That the User Exists!
个人分类: 数据库
So you’ve recently made a change to your mysql installation and see the following in
/var/lib/mysql/localhost.localdomain.err
-
080317 14:08:50 mysqld started
-
080317 14:08:50 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
-
080317 14:08:50 [ERROR] Aborting
-
080317 14:08:50 [Note] /usr/sbin/mysqld: Shutdown complete
-
080317 14:08:50 mysqld ended
This is a problem that many a time spent on google has not found the result, so I am writing here what exactly to do in this situation …
First off
cd /var/lib/mysql
Now run
ls -la
No doubt you will see something similar to this:
drwx--x--x 2 27 mysql 4096 Mar 17 14:05 mysql
Notice the “27 mysql”, the user no longer existsing in /etc/passwd.
This is fairly simple to fix.
adduser mysql
chown mysql:mysql -R /var/lib/mysql
Now start up Mysql i.e. “service start mysql” and everyhing should be fine.