当前位置:u赢电竞手机版 > uwin电竞app官网下载 > MySQL root密码重置报错:mysqladmin: connect to server

MySQL root密码重置报错:mysqladmin: connect to server

文章作者:uwin电竞app官网下载 上传时间:2019-06-26

 

登陆的时候加上sock参数就OK了。

     130506 17:40:19 [ERROR] /home/mysql/mysql/bin/mysqld: unknown variable 'inactive_timeout=172800'

owners.

     130506 17:40:19 [ERROR] Aborting

 

 

Oracle is a registered trademark of Oracle Corporation and/or its

Server无法启动错误诊断一则 mysql select version()G; *************************** 1. row *************************** version(): 5.5.16-log 1 row in set (0.00 sec) [m...

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

     1 row in set (0.00 sec)

130830 10:59:02  InnoDB: Started; log sequence number 0 2727887496

     [1] 3036

[[email protected] var]# service mysqld restart

     [[email protected] ~]$ 130506 19:16:34 mysqld_safe Logging to '/home/mysql/mysql/log/alert.log'.

 

MySQL Server无法启动错误诊断一则

[[email protected] var]#

     [[email protected] ~]$ mysqld_safe &

130830 10:59:03  InnoDB: Initializing buffer pool, size = 1.0G

     version(): 5.5.16-log

 

原来是inactive_timeout拼错了、该参数为interactive_timeout  

[分析]:不能写入默认的pid文件,就 修改 /etc/init.d/mysqld,把pid指向别的路经

 

Bye

     130506 19:16:36 mysqld_safe mysqld from pid file /home/mysql/mysql/data/cdio.pid ended

 

     130506 19:16:34 mysqld_safe Starting mysqld daemon with databases from /home/mysql/mysql/data

 

     *************************** 1. row ***************************

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

 

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

 mysql> select version()G;

1  登陆失败,mysqladmin修改密码失败

     

 

   查看日志、发现:

[[email protected] mysqld]#  /usr/bin/mysql -uroot -p

 

mysql> 

[[email protected] var]# 110407 17:39:28 mysqld_safe Logging to '/usr/local/mysql/var//mysql.chinascopefinanical.com.err'.

Welcome to the MySQL monitor.  Commands end with ; or g.

Shutting down MySQL..110407 17:45:29 mysqld_safe mysqld from pid file /usr/local/mysql/var//mysql.chinascopefinanical.com.pid ended

mysql> quit

130830 10:59:02 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)

110407 17:39:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var/

datadir="$result"

get_mysql_option mysqld socket "$datadir/mysql.sock"

 

SUCCESS!

[[email protected] var]# /etc/init.d/mysqld stop

Rows matched: 1  Changed: 1  Warnings: 0

[[email protected] var]# /usr/bin/mysql -uroot -p 【注释,在下面的要求你输入密码的时候,你不用管,直接回车键一敲就过去了】

Query OK, 0 rows affected (0.00 sec)

mysql> 

130830 10:59:02  InnoDB: Initializing buffer pool, size = 1.0G

 

affiliates. Other names may be trademarks of their respective

7 其他形式的错误情况分析

 

Starting MySQL.. SUCCESSuwin电竞app官网下载,!

 

root密码重置报错:mysqladmin: connect to server at localhost failed的解决方案 1 登陆失败,mysqladmin修改密码失败 [[email protected] var]# mysqladmin -u root pas...

 

 

 

Server version: 5.1.41-log Source distribution

[[email protected] mysqld]# 

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

 

Server version: 5.1.41-log Source distribution

errlogfile="$result"

 

然后启动mysqld服务,OK,成功了。  

mysql> use mysql;

 

Server version: 5.1.69 Source distribution

 

Your MySQL connection id is 6

/opt/mysql/product/5.5.25a/bin/mysqld_safe --skip-grant-tables &

 

本文由u赢电竞手机版发布于uwin电竞app官网下载,转载请注明出处:MySQL root密码重置报错:mysqladmin: connect to server

关键词: