Mysql问题小计

最新推荐文章于 2024-08-17 02:56:46 发布

someday0898

最新推荐文章于 2024-08-17 02:56:46 发布

阅读量161

点赞数

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/qq_15002353/article/details/109814257

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1问题：用navicat启动mysql提示10061

解决方法：mysql没启动，找不到mysql安装位置：使用开始--》搜索服务--》将mysql服务启动即可

2修改mysql密码问题：

使用mysqladmin修改mysqladmin -u root -p password "xxxx",linux端修改成功并能登陆，但是使用navicat以及其他检查工具还是使用原密码登陆，新修改的密码登陆不上

啥问题？？

网上使用如下方法解决：

use mysql;

UPDATE user SET authentication_string = PASSWORD('Smyptdb207root#@2021') WHERE User = 'root';

FLUSH PRIVILEGES;

mysql> use mysql;
Database changed
mysql> UPDATE user SET Password = PASSWORD('Smyptdb207root#@2021') WHERE User = 'root';
1054 - Unknown column 'Password' in 'field list'
mysql> show user;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user' at line 1
mysql> show table user;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user' at line 1
mysql> desc user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(32) | NO | PRI | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) unsigned | NO | | 0 | |
| plugin | char(64) | NO | | mysql_native_password | |
| authentication_string | text | YES | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
| password_last_changed | timestamp | YES | | NULL | |
| password_lifetime | smallint(5) unsigned | YES | | NULL | |
| account_locked | enum('N','Y') | NO | | N | |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
45 rows in set (0.05 sec)

mysql> UPDATE user SET password = PASSWORD('Smyptdb207root#@2021') WHERE User = 'root';
1054 - Unknown column 'password' in 'field list'
mysql> UPDATE user SET authentication_string = PASSWORD('Smyptdb207root#@2021') WHERE User = 'root';
Query OK, 1 row affected (0.26 sec)
Rows matched: 2 Changed: 1 Warnings: 1
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.14 sec)

mysql>