深圳企业黄页网站,泰安网络推广公司哪家好,新北仑网站怎么做的,做网站公司名字推荐1、连接服务器: mysql -u root -p2、看当前所有数据库#xff1a;show databases;
3、进入mysql数据库#xff1a;use mysql;
4、查看mysql数据库中所有的表#xff1a;show tables;
5、查看user表中的数据#xff1a;select Host, User,Password from user;
6、修改us…1、连接服务器: mysql -u root -p2、看当前所有数据库show databases;
3、进入mysql数据库use mysql;
4、查看mysql数据库中所有的表show tables;
5、查看user表中的数据select Host, User,Password from user;
6、修改user表中的Host:update user set Host‘%’ where User‘root’; 或者INSERT INTO mysql.user (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections, plugin, authentication_string, password_expired, password_last_changed, password_lifetime, account_locked, Create_role_priv, Drop_role_priv, Password_reuse_history, Password_reuse_time, Password_require_current, User_attributes) VALUES (‘%’, ‘root’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘’, ‘’, ‘’, ‘’, ‘0’, ‘0’, ‘0’, ‘0’, ‘mysql_native_password’, ‘*81F5E21E35407D884A6CD4A731AEAF209E1B’, ‘N’, ‘2023-01-10 17:59:05’, NULL, ‘N’, ‘Y’, ‘Y’, NULL, NULL, NULL, NULL);
7、最后刷新一下flush privileges;
