风烟

解决方案停止mysql然后进入root模式sudo su./mysqld_safe --skip-grant-tables &然后在执行mysql就可以进入了参考链接https://www.cnblogs.com/benbenzhu/p/5578162.html

报错提示mysql -uroot -pEnter password:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)在连接数据库的时候。连接不上，直接报了这个错误解决办法service mysqld start执行这个命令，启动mysqld。这个时候就可以连接上了。...

创建数据库CREATE DATABASE 数据库名;创建数据表CREATE TABLE IF NOT EXISTS `runoob_tbl`( `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id

mysql 报错信息ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)重启mysql解决、systemctl start mysqld.service

启动mysql报错原因systemctl start mysqld==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===Authentication is required to manage system services or units.Authenticating as: rootPassword:==== AUTHENTICATION COMPLETE ===Job for mysqld.service fa

https://dev.mysql.com/downloads/mysql/ 下载第一个mysql安装启动完成之后在～/.bash_profile里面增加PATH="$PATH":/usr/local/mysql/bin这样就可以直接在命令行登陆mysql -uroot -p...

nodejs连接mysql的时候报这个错误error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client代码let mysql = require('mysql');let con...

报错信息{ Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client这是自己在我的linux机器上，安装了mysql Ver 8.0.12 for Linux on x86_6...