`
yuanlanxiaup
  • 浏览: 859839 次
文章分类
社区版块
存档分类
最新评论

MySQL编译安装以后无法连接Can't connect to local MySQL server through socket '/usr/lib/mysql/data/mysql.sock'

 
阅读更多

Centos 6下手动编译安装MySQL,安装完了以后,启动服务正常,也能正常登录。

但是我今天再次启动机器,就出现了问题。

但是用命令登陆却出现问题

#mysql -u root -p

错误:

Can't connect to local MySQL server through socket '/usr/lib/mysql/data/mysql.sock'


用命令 /etc/rc.d/init.d/mysql status查看下状态,我擦,这mysql居然没有运行。如图:



/etc/rc.d/init.d/mysql start 启动下试试


启动起来了。

再试试service命令看下,似乎是没有添加到自动启动项里面。



运行chkconfig命令我发现,启动项根本就没有mysqld服务


好吧,添加服务,chkconfig --add mysqld,然后再次查看



OK,有mysqld服务了,然后也2-5自启动。

原因,之前拷贝mysqld文件到/etc/init.d目录中,也用service mysqld start命令。所以昨天运行正常。

但是因为没有添加mysqld服务为自启动,所以在重启后,他就没有运行。


解决:chkconfig --add mysqld


分享到:
评论

相关推荐

    Can’t connect to local MySQL through socket ‘/tmp/mysql.sock’解决方法

    ERROR 2002: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111) 解决办法: /usr/local/mysql/bin/mysqladmin -u root > -S /var/lib/mysql/mysql.sock password 'your.passwd' ...

    mysql for liunx 免安装版

    chown -R mysql:mysql /usr/local/mysql/data/ chown -R mysql:mysql /usr/local/mysql/lib/ chown -R mysql:mysql /usr/local/mysql/sock/ 启动:mysql服务 /usr/local/mysql/share/mysql/mysql.server start 进入...

    linux上安装mysql.pdf

    --datadir /usr/local/mysql/data MySQL数据目录 执行以下命令,创建初始数据库: Java代码 1. cd /usr/local/mysql 2. chown -R mysql . 3. chgrp -R mysql . 4. scripts/mysql_install_db --user=mysql --basedir=...

    CentOS 7.0编译安装cmake和mysql安装包

    ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql #生成mysql系统数据库 ln -s /usr/local/mysql/my.cnf /etc/my.cnf #添加到/etc目录的软连接 cp ./support-files/...

    runtime library [libssl.so.1.1] in /usr/lib/x86_64-linux-gnu may be hidden by files in:/home/

    编译ROS工程的过程中,因为安装了anaconda导致系统库的路径被覆盖掉,因而报错的时候 runtime library [libssl.so.1.1] in /usr/lib/x86_64-linux-gnu may be hidden by files in: /home/rw/anaconda3/lib 首先查看...

    解决Can’t locate ExtUtils/MakeMaker.pm in @INC报错

    Can’t locate ExtUtils/MakeMaker.pm in @INC (@INC contains: inc /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5

    linux下启动mysql服务

    ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) 解决办法: [root@test mysql]# /usr/local/mysql/bin/mysqladmin -u root / > -S /var/lib/mysql/mysql.sock ...

    mysql-8.0.20-macos10.15-x86_64.tar.gz

    _mysql 40907 0.4 2.1 4907248 350300 s000 S 5:46下午 0:00.95 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql...

    浅谈Linux 二进制包安装MySQL的一些问题

    第二步:初始化mysql数据库的内部信息./scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data ———————————————- 二进制包是否可以成功的运行,与先前是否先解决rpm...

    MySQL 5.6.25 源码包+安装方法 (mysql-5.6.25.tar.gz)

    # chown -R mysql:mysql /usr/local/mysql 4.2 初始化MySQL # scripts/mysql_install_db --user=mysql # cp support-files/mysql.server /etc/init.d/mysqld 4.3 重新设置MySQL安装目录的权限(除data目录外,其余...

    centos安装jdk1.8时出现没有/lib/ld-linux.so.2:这个文件的原因分析

    -bash: /usr/local/jdk/jdk1.8.0_181/bin/java: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory 安装完后 java -version 查看版本出现: 原因是:没有那个文件或目录,找了很久发现需要...

    LNMP架构安装

    ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=gbk,gb2312 make && make install cp support-files/my-medium.cnf /etc/my.cnf cp support-...

    qt环境安装

    自己的安装笔记,make阶段,出现一下错误 /usr/bin/ld: cannot find -lXrender collect2: ld returned 1 exit status make[1]: *** [../../../../lib/libQtWebKit.so.4.7.3] 错误 1 make[1]: Leaving directory,...

    mysql启动时报错:Starting MySQL… ERROR! The server quit without updating PID file

    给予权限,执行 "chown -R mysql.mysql /usr/local/mysql/data" 然后重新启动mysqld,最好是整个mysql程序目录都授权予mysql用户。 2、可能进程里已经存在mysql进程 解决方法: 用命令“ps -e

    环境搭建php&mysql&svn

    ./configure --prefix=/usr/local/webserver/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --...

    opencv移植到arm, 包含cmake包

    ../../lib/libopencv_highgui.so: undefined reference to `_TIFFerrorHandler' ../../lib/libopencv_highgui.so: undefined reference to `_TIFFrealloc' ../../lib/libopencv_core.so: undefined reference to `...

    安装lamp报错信息及解决方法

    /use/lib//usr/lib/libdb-4.2.so: could not read symbols: File in wrong format Notice: Following unknown configure options were used: usr/bin/ld: cannot find -lltdl /usr/bin/ld: cannot find -...

    libstdc++6_4.7.2-5_amd64.7z

    ./bin/mysqld: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.15' not found (required by ./bin/mysqld) ./bin/mysqld: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by ./bin/mysqld) libstdc...

    Auto install Mysql on CentOS

    1,将下载的镜像文件放到./usr/local 2,创建目录/data/mysql #mkdir -p /data/mysql 3,修改脚本内容,将“MYSQL='mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz'” 改成对应的镜像名 4,sudo ln -s /usr/lib64/...

    php-5.6.29.tar.gz

    编译 ./configure --prefix=/usr/local/...sock=/var/run/mysql/mysql.sock --with-mcrypt=/usr /i nclude --with-mhash --with-openssl --with-mysql=shared,mysqlnd --with-mysqli=shared,mysqlnd --with-pdo-mysql=...

Global site tag (gtag.js) - Google Analytics