输入命令后报错:
[root@dev1 mysql]# bin/mysqld_safe --user=mysql &
[1] 15325
[root@dev1 mysql]# 091217 22:22:53 mysqld_safe Logging to '/var/lib/mysql/dev1.sccl.cn.err'.
091217 22:22:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091217 22:23:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@dev1 mysql5.1]# bin/mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (1)
解决办法
vi /etc/my.cnf
把
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/run/mysql/mysqld.pid
改成
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysqld.pid
好现象,貌似启动成功了,插件进程
[root@dev1 log]# ps -aux | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
root 15526 0.0 0.0 5276 1112 pts/0 S 22:42 0:00 /bin/sh bin/mysqld_safe --user=mysql
mysql 15594 0.0 0.6 119232 14292 pts/0 Sl 22:42 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/dev1.sccl.cn.err --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 15613 0.0 0.0 5976 656 pts/0 S+ 22:44 0:00 grep mysql
但是登陆还是报错,修改如下:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
登陆老是提醒我登陆的用户名和密码不对,我重新设置了一下密码
mysql -u root(默认密码为空)
登陆
登陆终于成功了:),好事多磨啊。
相关推荐
prometheus mysql exporter 节点安装 mysqld_exporter-0.12.1.linux-amd64.tar.gz 资源下载
废话不多说了,直奔主题了。 mysql的四种启动方式: ...启动mysql服务器:./mysqld_safe –defaults-file=/etc/my.cnf –user=root & 客户端连接: mysql --defaults-file=/etc/my.cnf or mysql -S /t
mysqld_exporter安装包
mysqld_exporter安装包mysqld_exporter-0.12.0.linux-amd64.tar.gz
mysqld_exporter-0.14.0.linux-amd64.tar.gz
[mysqld] port=8899 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_allowed_packet=100M # Disabling symbolic-links is ...pid-file=/var/run/mysqld/mysqld.pid [client] port=8899
mysqld_exporter是Prometheus用于监控MySQL指标的一个导出器,支持对MySQL 5.5以上进行监控。下面是mysqld_exporter的安装与配置: 1、登录MySQL,创建一个账号用于Prometheus监控获取数据 CREATE USER 'exporter'...
MySQL常用工具介绍之服务器启停工具mysqld_safe、mysqlserver、mysqld_multi.docx
STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid 060304 11:46:21 mysqld ended 这是权限问题,我的mysql目录属于root用户,也属于root群组,改用 mysqld_safe启动就没问题了, ...
./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...
mysqld-dev_5.7.30-0ubuntu0.16.04.1_arm64离线安装包汇总: libmysqlclient18_5.5.35+dfsg-1ubuntu1_arm64.deb libssl-dev_1.1.1f-1ubuntu2_arm64.deb libmysqlclient20_5.7.30-0ubuntu0.16.04.1_arm64.deb mysql-...
第二步:初始化mysql数据库的内部信息./scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data ———————————————- 二进制包是否可以成功的运行,与先前是否先解决rpm...
注释:为了保持同旧版本MySQL的向后兼容性,MySQL二进制分发版仍然包括safe_mysqld作为mysqld_safe的符号链接。但是,你不应再依赖它,因为再将来将删掉它。 默认情况下,mysqld_safe尝试启动可执行mysqld-max...
centos7安装mysql8以及常规操作 -----------------------------...pid-file=/var/run/mysqld/mysqld.pid datadir=/mysql/data tmpdir=/mysql/tmp innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G:autoextend
Linux下安装初始化完MySQL数据库之后,使用mysqld_safe启动mysql数据库,如下发现,启动失败 [root@SVNServer bin]# ./mysqld_safe –user=mysql& 或 [root@SVNServer bin]# /etc/init.d/mysqld start Starting ...
> -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \ > -DWITH_DEBUG=0 \ > -DMYSQL_TCP_PORT=3306 # make # make install 4. 配置以及初始化MySQL # cd /usr/local/mysql 4.1 设置MySQL安装目录的权限 # chown -R mysql:mysql...
mysqld_safe脚本执行的基本流程:1、查找basedir和ledir。2、查找datadir和my.cnf。3、对my.cnf做一些检查,具体检查哪些选项请看附件中的注释。4、解析my.cnf中的组[mysqld]和[mysqld_safe]并和终端...8、启动mysqld.a)
mysql 5.7.x 所需mysqld.service文件
一、 四种启动方式: 1、mysqld 启动mysql服务器: ./...启动mysql服务器: ./mysqld_safe --defaults-file=/etc/my.cnf --user=root & 客户端连接: mysql --defaults-file=/etc/my.cnf 或 mysql -S /tm/mysql.soc
首先是不知道怎么忽然mysql用命令行,workbench都登录不了,都提示’Access denied for user ‘root’@’localhost’。 数据库卸载重装了几次都不行。...可能提示mysqld_safe Directory ‘/var/run/mysqld