linux 下安装 MySQL 经常出现各种问题终极解决方法 /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.pid
来源:互联网 发布:q宠大乐斗门派技能数据 编辑:程序博客网 时间:2024/06/05 04:52
以为 ubuntu 12.04 为例:
安装 MySQL 5.5 ,方法如下:
参考网址:http://blog.csdn.net/ichsonx/article/details/9285935(推荐此方式安装!!!!!,里面有详细,注意安装文件如下方式获取)
wget http://sourceforge.net/projects/mysql.mirror/files/MySQL%205.5.27/mysql-5.5.27-linux2.6-x86_64.tar.gz( 在/usr/local/目录下执行该命令,推荐,因为我安装tar.gz,并参考网址进行安装)
安装好后,通过命令: ps -ef|grep mysql; 命令可以查看mysql 运行信息,比如运行mysql程序所在bin目录,如下:
root 11761 25202 0 20:05 pts/3 00:00:00 /bin/sh bin/mysqld_safe --user=mysql
mysql 11999 11761 0 20:05 pts/3 00:00:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin -
-user=mysql --log-error=/usr/local/mysql/data/AY1407041941145052b9Z.err --pid-file=/usr/local/mysql/data/AY1407041941145052b9Z.pid --socket=/tmp/mysql.sock --port=3306
root 12732 25202 0 20:27 pts/3 00:00:00 mysql -uroot -p
root 13060 25202 0 20:35 pts/3 00:00:00 grep --color=auto mysql
(到这里强烈建议大家把以上运行信息复制保存起来!!!!!,后面安装其他软件或者运行有时会遇到各类问题可以参照以上信息进行修改)
输入 ln -s 建立软连接,如下:
ln -s /usr/local/mysql/bin/mysql /usr/bin/; ===>>>> 这样就可以直接通过命令行直接输入 mysql -uroot -p 进入mysql了!
ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/;
ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/;
ln -s /usr/local/mysql/bin/mysql_conf /usr/bin/;
ln -s /usr/local/mysql/share/mysql/mysql.server /usr/bin/;
到此安装完成!
启用远程连接访问数据库:
输入mysql -uroot -p 进入 mysql 命令环境,输入如下指令,允许远程登录权限:
1.
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2.
修改 my.cnf 配置文件 将 bind-address = 127.0.0.1 此行注释掉,然后重启 /etc/init.d/mysql.server restart
这样就用SQLyogEnt.exe远程连接了!!
安装完后,会经常遇到如下各种问题,如找不到:
/var/run/mysqld/mysqld.sock
/var/run/mysqld/mysqld.pid 这之类的信息,这里就可以用上【之前保存的】诸如以下相关信息:
basedir=,datadir=,user=,pid-file=,log-error=,socket=,port=,
要解决这之类的问题,一般是通过修改过配置文件 /etc/init.d/my.cnf(有的是/etc/my.cnf ,还有的是/etc/mysql/my.cnf), 把以上保存的信息修改到 my.cnf 配置文件中,
另外在 my.cnf 配置中 [mysqld] 下: lc-messages-dir = /usr/local/mysql/share (/usr/local/mysql/为安装目录,share为安装目录下的共享文件),这里也很重要哦!
改完然后后重启mysql:/etc/init.d/mysql.server restart/start; 即可!!! 若如出现改了还是依然无效,则键入 find / -name my.cnf 命令查看my.cnf存在哪些目录下,只能有一个启动的有效,比如5.5 的版本在 /etc/mysql/my.cnf 有一个!!!删除其他多余的再去修改,可能启动的my.cnf 文件并不是修改的那一个..!!!!
这样如果在之后遇到此类似的问题,就可以安装这种方法彻底解决问题!
- linux 下安装 MySQL 经常出现各种问题终极解决方法 /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.pid
- mysql.sock -> /var/run/mysqld/mysqld.sock
- linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- Linux Mysql无法启动 /var/run/mysqld/mysqld.sock
- 错误: MySQL server through socket '/var/run/mysqld/mysqld.sock‘
- Linux mysql安装无法启动 /etc下无mysql配置文件,mysql 无法启动,/var/run/mysqld/mysqld.sock找不到
- 04-MySQL-Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- Mysql运行的STOPPING server from pid file /var/run/mysqld/mysqld.pid错误
- Mysql连接的过程中出现Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- mysql启动不了报 /var/run/mysqld/mysqld.sock无法连接的解决办法
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Oracle实例恢复(Oracle instance recovery)
- 错误1error C1189: #error : This file requires _WIN32_WINNT to be #defined at least to 0x0403. Value
- cocos2dx 3.x schedule的认识
- ORA-00600: internal error code, arguments: [15851], [8], [8], [1], [2], [], [], []
- stm32中断与事件
- linux 下安装 MySQL 经常出现各种问题终极解决方法 /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.pid
- ajax 做 长轮序 session 阻塞问题
- poj 3468 A Simple Problem with Integers
- NYOJ 58 最少步数
- hello World!
- Cocos2d-x 2.2.3 使用NDK配置安卓编译环境问题之 Cannot find module with tag 'CocosDenshion/android' in import path
- poj 3321 Apple Tree
- Java,Mysql-根据一个给定经纬度的点,进行附近500米地点查询–合理利用算法
- hdu1754___I Hate It (线段树)