mysql 局域网数据库共享_局域网里的Mysql共用问题

展开全部

建立一个可以有管理权限的636f70793231313335323631343130323136353331333332623934并能远程访问的帐号

下面是建立一个帐号为admin,密码为admin的可以远程访问的管理员权限的语句

在mysql数据库里建立insert into user

select '%','admin','*4ACFE3202A5FF5CF467898FC58AAB1D615029441',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,ssl_type,ssl_cipher,x509_issuer,x509_subject,

max_questions,max_updates,max_connections,max_user_connections

from user where host='localhost'