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
分享到:
相关推荐
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' ...
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 ...
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 进入...
--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=...
./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/...
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
编译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 首先查看...
_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...
第二步:初始化mysql数据库的内部信息./scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data ———————————————- 二进制包是否可以成功的运行,与先前是否先解决rpm...
/usr/local/arm/5.4.0/usr/bin/../libexec/gcc/arm-none-linux-gnueabi/5.4.0/cc1: error while loading shared libraries: libmpfr.so.4: cannot open shared object file: No such file or directory 解决方法: ...
# 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目录外,其余...
./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-...
自己的安装笔记,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,...
-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 查看版本出现: 原因是:没有那个文件或目录,找了很久发现需要...
./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 --...
../../lib/libopencv_highgui.so: undefined reference to `_TIFFerrorHandler' ../../lib/libopencv_highgui.so: undefined reference to `_TIFFrealloc' ../../lib/libopencv_core.so: undefined reference to `...
/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 -...
给予权限,执行 "chown -R mysql.mysql /usr/local/mysql/data" 然后重新启动mysqld,最好是整个mysql程序目录都授权予mysql用户。 2、可能进程里已经存在mysql进程 解决方法: 用命令“ps -e
出现以下报错,替换/usr/local/include/openssl里面的文件之后编译成功。add_assoc_name_entry’:/data/src/php-5.6.23/ext/openssl/openssl.c:664: warning: ‘ASN1_STRING_data’ is deprecated (declared at /usr...
./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...