安装完mysql后,执行
mysqld_safe --user=mysql & 命令报以下错误:
[root@zrf ~]#
/usr/local/mysql/bin/mysqld_safe --user=mysql&
[1] 3527
[root@zrf ~]# 101021 16:37:39 mysqld_safe Logging to '/usr/local/mysql/data/zrf.err'.
101021 16:37:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
101021 16:37:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/zrf.pid ended
查看 zrf.err 日志文件,其信息为:
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
101021 16:37:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101021 16:37:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
101021 16:37:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/zrf.pid ended
101021 16:41:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
101021 16:41:17 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--sk
ip-external-locking' instead.
解决办法:
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql
问题已解决!
分享到:
相关推荐
./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...
/usr/local/mysql/bin/safe_mysqld--uer=root&(注意 safe_mysqld与mysqld_safe是不同的,&表示mysql在后台运行)我的就会报错了 STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid ...
错误信息例如: 代码如下:[code] mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/imysql.
废话不多说了,直奔主题了。 mysql的四种启动方式: ...启动mysql服务器:./mysqld_safe –defaults-file=/etc/my.cnf –user=root & 客户端连接: mysql --defaults-file=/etc/my.cnf or mysql -S /t
第二步:初始化mysql数据库的内部信息./scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data ———————————————- 二进制包是否可以成功的运行,与先前是否先解决rpm...
prometheus mysql exporter 节点安装 mysqld_exporter-0.12.1.linux-amd64.tar.gz 资源下载
首先是不知道怎么忽然mysql用命令行,workbench都登录不了,都提示’Access denied for ...以安全模式启动MySQL~$ sudo mysqld_safe --skip-grant-tables & 注意: 可能提示mysqld_safe Directory ‘/var/run/mysqld
到此这篇关于Linux bash:./xxx:无法执行二进制文件报错的文章就介绍到这了,更多相关Linux 无法执行二进制文件 内容请搜索软件开发网以前的文章或继续浏览下面的相关文章希望大家以后多多支持软件开发网!...
/usr/lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.21' not found 操作方法:#rm /usr/lib/x86_64-linux-gnu# rm libstdc++.so.6 #ln libstdc++.so.6.0.20 libstdc++.so.6 #strings /usr/lib/x86_64...
> -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)
[root@SVNServer bin]# ./mysqld_safe –user=mysql& 或 [root@SVNServer bin]# /etc/init.d/mysqld start Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/AY...
解决linux下出现/lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found问题,包含libstdc++.so.6.0.23文件和使用说明文档
mysql:安装路径/usr/local/mysql,配置文件路径/etc/my.cnf redis:安装路径/usr/local/redis,配置文件redis.cnf路径/usr/local/redis/bin/ mongodb:安装路径/usr/local/mongodb 启动命令: mysqld --user=root ...
mysql启动时报错信息如下:Starting MySQL… ERROR! The server quit without updating PID file ? 出现问题的可能性 1、可能是/usr/local/mysql/data/数据目录mysql用户没有权限(修改数据目录的权限) 解决方法 :...
MySQL常用工具介绍之服务器启停工具mysqld_safe、mysqlserver、mysqld_multi.docx
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-5.7.22/ --datadir=/usr/local/mysql/mysql-5.7.22/data --lc_messages_dir=/usr/local/mysql/mysql-5.7.22/share --lc_messages=en_US ...
./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/...
mysqld_exporter是Prometheus用于监控MySQL指标的一个导出器,支持对MySQL 5.5以上进行监控。下面是mysqld_exporter的安装与配置: 1、登录MySQL,创建一个账号用于Prometheus监控获取数据 CREATE USER 'exporter'...