| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> shi yong shi li guan li qi qing song guan li duo ge MySQL shi li

shi yong shi li guan li qi qing song guan li duo ge MySQL shi li

2008-06-01 03:23:19 编辑來源:互联网 评论
 
 
 
本文为【使用实例管理器轻松管理多个MySQL实例】的拼音翻译版
  yi 、MySQL shu ju ku de shi li guan li qi gai shu :
  1、MySQL shu ju ku de shi li guan li qi (IM) shi tong guo TCP/IP duan kou yun xing de hou tai cheng xu , yong lai jian shi he guan li MySQL shu ju ku fu wu qi shi li 。
  2、 jia ru IM gua le , ze suo you de shi li dou hui gua diao ; jia ru shi li gua le ,IM hui chang shi chong xin lai qi dong ta 。
  3、IM du qu pei zhi wen jian bi ru MY.CNF de [manager] duan 。
  4、 ben wen zhong de shi li yi ju LINUX huan jing xia shi yan 。
  er 、 pei zhi shuo ming :
  1、 pei zhi wen jian ru xia :
  [manager]
  user=mysql
  default-mysqld-path = /usr/local/mysql/bin/mysqld
  socket=/tmp/manager.sock
  pid-file=/tmp/manager.pid
  password-file = /etc/mysqlmanager.passwd
  monitoring-interval = 2
  port = 1999
  bind-address = 192.168.0.231
  log = /usr/local/mysql/bin/mysqlmanager.log
  run-as-service = true
  [mysqld1]
  ...
  [mysqld2]
  ...
  zhe ge you liang ge pei zhi shi li , ju ti jiu bu shuo le 。 jian wo de an zhuang duo ge shi li de wen zhang 。
  ju ti han yi cha kan mysqlmanager --help
  2、 mi ma wen jian
  IM jiang yong hu xin xi bao cun dao mi ma wen jian zhong 。 mi ma wen jian de mo ren wei zhi wei /etc/mysqlmanager.passwd。
  mi ma ying lei si yu :
  petr:*35110DC9B4D8140F5DE667E28C72DD2597B5C848
  wo de mysqlmanager.passwd nei rong
  user_all:*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
  3、 qi dong IM
  [root@localhost tmp]# /usr/local/mysql/bin/mysqlmanager
  WARNING: This program is deprecated and will be removed in 6.0.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] IM: started.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Loading config file 'my.cnf'...
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: initializing...
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: detected threads model: POSIX threads.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Loading the password database...
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Loaded user 'user_all'.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] The password database loaded successfully.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: pid file (/tmp/manager.pid) created.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] mysqld instance 'mysqld1' has been added successfully.
  [2483/3086632640] [08/04/24 14:24:50] [INFO] mysqld instance 'mysqld2' has been added successfully.
  [2483/3076139920] [08/04/24 14:24:50] [INFO] Guardian: started.
  [2483/3076139920] [08/04/24 14:24:50] [INFO] Guardian: starting 'mysqld1'...
  [2483/3076058000] [08/04/24 14:24:50] [INFO] Instance 'mysqld1': Monitor: started.
  [2483/3076058000] [08/04/24 14:24:50] [INFO] Instance 'mysqld1': Monitor: starting mysqld...
  [2483/3076139920] [08/04/24 14:24:50] [INFO] Guardian: starting 'mysqld2'...
  [2483/3076058000] [08/04/24 14:24:50] [INFO] Instance 'mysqld1': Monitor: waiting for mysqld to stop...
  [2483/3075894160] [08/04/24 14:24:50] [INFO] Instance 'mysqld2': Monitor: started.
  [2483/3075894160] [08/04/24 14:24:50] [INFO] Instance 'mysqld2': Monitor: starting mysqld...
  [2483/3075894160] [08/04/24 14:24:50] [INFO] Instance 'mysqld2': Monitor: waiting for mysqld to stop...
  [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: started.
  [2483/3075976080] [08/04/24 14:24:50] [INFO] Listener: started.
  [2483/3075976080] [08/04/24 14:24:50] [INFO] Listener: accepting connections on ip socket (port: 1999)...
  [2483/3075976080] [08/04/24 14:24:50] [INFO] Listener: accepting connections on unix socket '/tmp/manager.sock'...
  ...
  InnoDB: than specified in the .cnf file 0 5242880 bytes!
  080424 14:24:50 InnoDB: Started; log sequence number 0 46409
  080424 14:24:50 [Note] Event Scheduler: Loaded 0 events
  080424 14:24:50 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  Version: '5.1.23a-maria-alpha-log' socket: '/tmp/mysql1.sock' port: 3306 MySQL Community Server [Maria] (GPL)
  080424 14:24:50 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
  080424 14:24:50 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.
  080424 14:24:50 [Note] Event Scheduler: Loaded 0 events
  080424 14:24:50 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  Version: '5.1.23a-maria-alpha-log' socket: '/tmp/mysql2.sock' port: 3309 MySQL Community Server [Maria] (GPL)
  [2483/3076139920] [08/04/24 14:24:52] [INFO] Guardian: 'mysqld1' is running, set state to STARTED.
  
  4、 lian jie IM
  [root@localhost ~]# mysql -uuser_all -p -S/tmp/manager.sock -P1999
  san 、 yong IM lai guan li MySQL shu ju ku
  1、 xian shi shi li de zhuang tai he ban ben xin xi
  [root@localhost ~]# mysql -uuser_all -p -S/tmp/manager.sock -P1999
  Enter password:
  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is 1
  Server version: 1.0-beta
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  mysql> show instances;
  +---------------+--------+
  | instance_name | state |
  +---------------+--------+
  | mysqld1 | online |
  | mysqld2 | online |
  +---------------+--------+
  2 rows in set (0.00 sec)
  guan bi shi li 1
  mysql> stop instance mysqld1;
  Query OK, 0 rows affected (0.30 sec)
  mysql> show instances;
  +---------------+---------+
  | instance_name | state |
  +---------------+---------+
  | mysqld1 | offline |
  | mysqld2 | online |
  +---------------+---------+
  2 rows in set (0.00 sec)
  kai qi shi li 1
  mysql> start instance mysqld1;
  Query OK, 0 rows affected (0.00 sec)
  Instance started
  mysql> show instances;
  +---------------+--------+
  | instance_name | state |
  +---------------+--------+
  | mysqld1 | online |
  | mysqld2 | online |
  +---------------+--------+
  2 rows in set (0.00 sec)
  cha kan shi li de ban ben xin xi
  mysql> show instance status mysqld2;
  +---------------+--------+----------------+
  | instance_name | state | version_number | version | mysqld_compatible |
  +---------------+--------+----------------+
  | mysqld2 | online | 5.1.23 | 5.1.23a-maria-alpha for redhat-linux-gnu on i686 (MySQL Community Server [Maria] (GPL))
  | no |
  +---------------+--------+----------------+
  1 row in set (0.00 sec)
  ye ke yi xian shi shi li de xuan xiang xin xi
  mysql> show instance options mysqld1;
  +-----------------------+-----------------------------------+
  | option_name | value |
  +-----------------------+-----------------------------------+
  | instance_name | mysqld1 |
  | basedir | /usr/local/mysql |
  | datadir | /usr/local/mysql/data |
  | user | mysql |
  | default-character-set | utf8 |
  | port | 3306 |
  | socket | /tmp/mysql1.sock |
  | skip-locking | |
  | skip-name-resolve | |
  | key_buffer | 126M |
  | max_allowed_packet | 2M |
  | table_cache | 512 |
  | sort_buffer_size | 2M |
  | read_buffer_size | 2M |
  | read_rnd_buffer_size | 4M |
  | net_buffer_length | 2K |
  | thread_stack | 64K |
  | log-bin | mysql.log |
  | expire_logs_days | 5 |
  | wait_timeout | 20 |
  | pid-file | mysqld1-localhost.localdomain.pid |
  +-----------------------+-----------------------------------+
  21 rows in set (0.00 sec)
  ye ke yi cha xun shi li de ri zhi xiang guan xin , bu zai zhui shu 。
  wo men ke yi fa xian , guan li shi li qi shi fei chang fang bian 。
  2、 guan li yong hu
  (1)、 tian jia guan li yong hu
  [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --add-user
  WARNING: This program is deprecated and will be removed in 6.0.
  [3046/3086816960] [08/04/24 14:33:13] [INFO] IM: started.
  [3046/3086816960] [08/04/24 14:33:13] [INFO] Loading config file 'my.cnf'...
  Enter user name: shit_all
  [3046/3086816960] [08/04/24 14:33:18] [INFO] Loading the password database...
  [3046/3086816960] [08/04/24 14:33:18] [INFO] Loaded user 'user_all'.
  [3046/3086816960] [08/04/24 14:33:18] [INFO] The password database loaded successfully.
  Enter password:
  Re-type password:
  [3046/3086816960] [08/04/24 14:33:23] [INFO] IM: finished.
  [root@localhost ~]# cat /etc/mysqlmanager.passwd
  user_all:*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
  shit_all:*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
  zhu yi : bi xu chong xin qi dong IM cai neng sheng xiao 。
  [root@localhost ~]# mysql -ushit_all -p -S/tmp/manager.sock -P1999
  Enter password:
  ERROR 1045 (28000): Access denied. Bad username/password pair
  (2)、 xiu gai yong hu mi ma
  [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --edit-user
  WARNING: This program is deprecated and will be removed in 6.0.
  [3214/3086845632] [08/04/24 14:35:15] [INFO] IM: started.
  [3214/3086845632] [08/04/24 14:35:15] [INFO] Loading config file 'my.cnf'...
  Enter user name: shit_all
  [3214/3086845632] [08/04/24 14:35:19] [INFO] Loading the password database...
  [3214/3086845632] [08/04/24 14:35:19] [INFO] Loaded user 'user_all'.
  [3214/3086845632] [08/04/24 14:35:19] [INFO] Loaded user 'shit_all'.
  [3214/3086845632] [08/04/24 14:35:19] [INFO] The password database loaded successfully.
  Enter password:
  Re-type password:
  [3214/3086845632] [08/04/24 14:35:24] [INFO] IM: finished.
  
  (3)、 shan chu yong hu
  [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --drop-user
  WARNING: This program is deprecated and will be removed in 6.0.
  [3338/3086501568] [08/04/24 14:36:42] [INFO] IM: started.
  [3338/3086501568] [08/04/24 14:36:42] [INFO] Loading config file 'my.cnf'...
  Enter user name: shit_all
  [3338/3086501568] [08/04/24 14:36:45] [INFO] Loading the password database...
  [3338/3086501568] [08/04/24 14:36:45] [INFO] Loaded user 'user_all'.
  [3338/3086501568] [08/04/24 14:36:45] [INFO] Loaded user 'shit_all'.
  [3338/3086501568] [08/04/24 14:36:45] [INFO] The password database loaded successfully.
  [3338/3086501568] [08/04/24 14:36:45] [INFO] IM: finished.
  (4)、 lie chu dang qian guan li yong hu
  [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --list-user
  WARNING: This program is deprecated and will be removed in 6.0.
  [3366/3086087872] [08/04/24 14:37:07] [INFO] IM: started.
  [3366/3086087872] [08/04/24 14:37:07] [INFO] Loading config file 'my.cnf'...
  [3366/3086087872] [08/04/24 14:37:07] [INFO] Loading the password database...
  [3366/3086087872] [08/04/24 14:37:07] [INFO] Loaded user 'user_all'.
  [3366/3086087872] [08/04/24 14:37:07] [INFO] The password database loaded successfully.
  user_all
  [3366/3086087872] [08/04/24 14:37:07] [INFO] IM: finished.
  [root@localhost ~]#
  si 、 yuan cheng guan li
  C:\Documents and Settings\Administrator>mysql -uuser_all -p -P1999 -h192.168.0.2
  31
  Enter password: ******
  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is 3
  Server version: 1.0-beta
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  mysql> show instances;
  +---------------+--------+
  | instance_name | state |
  +---------------+--------+
  | mysqld1 | online |
  | mysqld2 | online |
  +---------------+--------+
  2 rows in set (0.00 sec)
  mysql> quit
  zong jie :
  MySQL shu ju ku de shi li guan li qi dui yu duo ge MySQL shi li de guan li shi hen fang bian de , dan ta ben shen cun zai liang ge bu zu :
  1、 bu neng zhi jie jin xing shu ju ku de SQL guan li ming ling 。
  2、 yi ding yao que bao IM jin cheng bu hui tu ran gua diao 。【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
yi 、MySQL shu ju ku de shi li guan li qi gai shu : 1、MySQL shu ju ku de shi li guan li qi (IM) shi tong guo TCP/IP duan kou yun xing de hou tai cheng xu , yong lai jian shi he guan li MySQL shu ju ku fu wu qi shi li 。 2、 jia ru IM gua le , ze suo you de shi li dou hui gua diao ; jia ru shi li gua le ,IM hui chang shi chong xin lai qi dong ta 。 3、IM du qu pei zhi wen jian bi ru MY.CNF de [manager] duan 。 4、 ben wen zhong de shi li yi ju LINUX huan jing xia shi yan 。 er 、 pei zhi shuo ming : 1、 pei zhi wen jian ru xia : [manager] user=mysql default-mysqld-path = /usr/local/mysql/bin/mysqld socket=/tmp/manager.sock pid-file=/tmp/manager.pid password-file = /etc/mysqlmanager.passwd monitoring-interval = 2 port = 1999 bind-address = 192.168.0.231 log = /usr/local/mysql/bin/mysqlmanager.log run-as-service = true [mysqld1] ... [mysqld2] ... zhe ge you liang ge pei zhi shi li , ju ti jiu bu shuo le 。 jian wo de an zhuang duo ge shi li de wen zhang 。 ju ti han yi cha kan mysqlmanager --help 2、 mi ma wen jian IM jiang yong hu xin xi bao cun dao mi ma wen jian zhong 。 mi ma wen jian de mo ren wei zhi wei /etc/mysqlmanager.passwd。 mi ma ying lei si yu : petr:*35110DC9B4D8140F5DE667E28C72DD2597B5C848 wo de mysqlmanager.passwd nei rong user_all:*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 3、 qi dong IM [root@localhost tmp]# /usr/local/mysql/bin/mysqlmanager WARNING: This program is deprecated and will be removed in 6.0. [2483/3086632640] [08/04/24 14:24:50] [INFO] IM: started. [2483/3086632640] [08/04/24 14:24:50] [INFO] Loading config file 'my.cnf'... [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: initializing... [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: detected threads model: POSIX threads. [2483/3086632640] [08/04/24 14:24:50] [INFO] Loading the password database... [2483/3086632640] [08/04/24 14:24:50] [INFO] Loaded user 'user_all'. [2483/3086632640] [08/04/24 14:24:50] [INFO] The password database loaded successfully. [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: pid file (/tmp/manager.pid) created. [2483/3086632640] [08/04/24 14:24:50] [INFO] mysqld instance 'mysqld1' has been added successfully. [2483/3086632640] [08/04/24 14:24:50] [INFO] mysqld instance 'mysqld2' has been added successfully. [2483/3076139920] [08/04/24 14:24:50] [INFO] Guardian: started. [2483/3076139920] [08/04/24 14:24:50] [INFO] Guardian: starting 'mysqld1'... [2483/3076058000] [08/04/24 14:24:50] [INFO] Instance 'mysqld1': Monitor: started. [2483/3076058000] [08/04/24 14:24:50] [INFO] Instance 'mysqld1': Monitor: starting mysqld... [2483/3076139920] [08/04/24 14:24:50] [INFO] Guardian: starting 'mysqld2'... [2483/3076058000] [08/04/24 14:24:50] [INFO] Instance 'mysqld1': Monitor: waiting for mysqld to stop... [2483/3075894160] [08/04/24 14:24:50] [INFO] Instance 'mysqld2': Monitor: started. [2483/3075894160] [08/04/24 14:24:50] [INFO] Instance 'mysqld2': Monitor: starting mysqld... [2483/3075894160] [08/04/24 14:24:50] [INFO] Instance 'mysqld2': Monitor: waiting for mysqld to stop... [2483/3086632640] [08/04/24 14:24:50] [INFO] Manager: started. [2483/3075976080] [08/04/24 14:24:50] [INFO] Listener: started. [2483/3075976080] [08/04/24 14:24:50] [INFO] Listener: accepting connections on ip socket (port: 1999)... [2483/3075976080] [08/04/24 14:24:50] [INFO] Listener: accepting connections on unix socket '/tmp/manager.sock'... ... InnoDB: than specified in the .cnf file 0 5242880 bytes! 080424 14:24:50 InnoDB: Started; log sequence number 0 46409 080424 14:24:50 [Note] Event Scheduler: Loaded 0 events 080424 14:24:50 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.1.23a-maria-alpha-log' socket: '/tmp/mysql1.sock' port: 3306 MySQL Community Server [Maria] (GPL) 080424 14:24:50 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode. 080424 14:24:50 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode. 080424 14:24:50 [Note] Event Scheduler: Loaded 0 events 080424 14:24:50 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.1.23a-maria-alpha-log' socket: '/tmp/mysql2.sock' port: 3309 MySQL Community Server [Maria] (GPL) [2483/3076139920] [08/04/24 14:24:52] [INFO] Guardian: 'mysqld1' is running, set state to STARTED. 4、 lian jie IM [root@localhost ~]# mysql -uuser_all -p -S/tmp/manager.sock -P1999 san 、 yong IM lai guan li MySQL shu ju ku 1、 xian shi shi li de zhuang tai he ban ben xin xi [root@localhost ~]# mysql -uuser_all -p -S/tmp/manager.sock -P1999 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 1.0-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show instances; +---------------+--------+ | instance_name | state | +---------------+--------+ | mysqld1 | online | | mysqld2 | online | +---------------+--------+ 2 rows in set (0.00 sec) guan bi shi li 1 mysql> stop instance mysqld1; Query OK, 0 rows affected (0.30 sec) mysql> show instances; +---------------+---------+ | instance_name | state | +---------------+---------+ | mysqld1 | offline | | mysqld2 | online | +---------------+---------+ 2 rows in set (0.00 sec) kai qi shi li 1 mysql> start instance mysqld1; Query OK, 0 rows affected (0.00 sec) Instance started mysql> show instances; +---------------+--------+ | instance_name | state | +---------------+--------+ | mysqld1 | online | | mysqld2 | online | +---------------+--------+ 2 rows in set (0.00 sec) cha kan shi li de ban ben xin xi mysql> show instance status mysqld2; +---------------+--------+----------------+ | instance_name | state | version_number | version | mysqld_compatible | +---------------+--------+----------------+ | mysqld2 | online | 5.1.23 | 5.1.23a-maria-alpha for redhat-linux-gnu on i686 (MySQL Community Server [Maria] (GPL)) | no | +---------------+--------+----------------+ 1 row in set (0.00 sec) ye ke yi xian shi shi li de xuan xiang xin xi mysql> show instance options mysqld1; +-----------------------+-----------------------------------+ | option_name | value | +-----------------------+-----------------------------------+ | instance_name | mysqld1 | | basedir | /usr/local/mysql | | datadir | /usr/local/mysql/data | | user | mysql | | default-character-set | utf8 | | port | 3306 | | socket | /tmp/mysql1.sock | | skip-locking | | | skip-name-resolve | | | key_buffer | 126M | | max_allowed_packet | 2M | | table_cache | 512 | | sort_buffer_size | 2M | | read_buffer_size | 2M | | read_rnd_buffer_size | 4M | | net_buffer_length | 2K | | thread_stack | 64K | | log-bin | mysql.log | | expire_logs_days | 5 | | wait_timeout | 20 | | pid-file | mysqld1-localhost.localdomain.pid | +-----------------------+-----------------------------------+ 21 rows in set (0.00 sec) ye ke yi cha xun shi li de ri zhi xiang guan xin , bu zai zhui shu 。 wo men ke yi fa xian , guan li shi li qi shi fei chang fang bian 。 2、 guan li yong hu (1)、 tian jia guan li yong hu [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --add-user WARNING: This program is deprecated and will be removed in 6.0. [3046/3086816960] [08/04/24 14:33:13] [INFO] IM: started. [3046/3086816960] [08/04/24 14:33:13] [INFO] Loading config file 'my.cnf'... Enter user name: shit_all [3046/3086816960] [08/04/24 14:33:18] [INFO] Loading the password database... [3046/3086816960] [08/04/24 14:33:18] [INFO] Loaded user 'user_all'. [3046/3086816960] [08/04/24 14:33:18] [INFO] The password database loaded successfully. Enter password: Re-type password: [3046/3086816960] [08/04/24 14:33:23] [INFO] IM: finished. [root@localhost ~]# cat /etc/mysqlmanager.passwd user_all:*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 shit_all:*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 zhu yi : bi xu chong xin qi dong IM cai neng sheng xiao 。 [root@localhost ~]# mysql -ushit_all -p -S/tmp/manager.sock -P1999 Enter password: ERROR 1045 (28000): Access denied. Bad username/password pair (2)、 xiu gai yong hu mi ma [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --edit-user WARNING: This program is deprecated and will be removed in 6.0. [3214/3086845632] [08/04/24 14:35:15] [INFO] IM: started. [3214/3086845632] [08/04/24 14:35:15] [INFO] Loading config file 'my.cnf'... Enter user name: shit_all [3214/3086845632] [08/04/24 14:35:19] [INFO] Loading the password database... [3214/3086845632] [08/04/24 14:35:19] [INFO] Loaded user 'user_all'. [3214/3086845632] [08/04/24 14:35:19] [INFO] Loaded user 'shit_all'. [3214/3086845632] [08/04/24 14:35:19] [INFO] The password database loaded successfully. Enter password: Re-type password: [3214/3086845632] [08/04/24 14:35:24] [INFO] IM: finished. (3)、 shan chu yong hu [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --drop-user WARNING: This program is deprecated and will be removed in 6.0. [3338/3086501568] [08/04/24 14:36:42] [INFO] IM: started. [3338/3086501568] [08/04/24 14:36:42] [INFO] Loading config file 'my.cnf'... Enter user name: shit_all [3338/3086501568] [08/04/24 14:36:45] [INFO] Loading the password database... [3338/3086501568] [08/04/24 14:36:45] [INFO] Loaded user 'user_all'. [3338/3086501568] [08/04/24 14:36:45] [INFO] Loaded user 'shit_all'. [3338/3086501568] [08/04/24 14:36:45] [INFO] The password database loaded successfully. [3338/3086501568] [08/04/24 14:36:45] [INFO] IM: finished. (4)、 lie chu dang qian guan li yong hu [root@localhost ~]# /usr/local/mysql/bin/mysqlmanager --list-user WARNING: This program is deprecated and will be removed in 6.0. [3366/3086087872] [08/04/24 14:37:07] [INFO] IM: started. [3366/3086087872] [08/04/24 14:37:07] [INFO] Loading config file 'my.cnf'... [3366/3086087872] [08/04/24 14:37:07] [INFO] Loading the password database... [3366/3086087872] [08/04/24 14:37:07] [INFO] Loaded user 'user_all'. [3366/3086087872] [08/04/24 14:37:07] [INFO] The password database loaded successfully. user_all [3366/3086087872] [08/04/24 14:37:07] [INFO] IM: finished. [root@localhost ~]# si 、 yuan cheng guan li C:\Documents and Settings\Administrator>mysql -uuser_all -p -P1999 -h192.168.0.2 31 Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 1.0-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show instances; +---------------+--------+ | instance_name | state | +---------------+--------+ | mysqld1 | online | | mysqld2 | online | +---------------+--------+ 2 rows in set (0.00 sec) mysql> quit zong jie : MySQL shu ju ku de shi li guan li qi dui yu duo ge MySQL shi li de guan li shi hen fang bian de , dan ta ben shen cun zai liang ge bu zu : 1、 bu neng zhi jie jin xing shu ju ku de SQL guan li ming ling 。 2、 yi ding yao que bao IM jin cheng bu hui tu ran gua diao 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
玉美人_珠联璧合
清纯美女米卡
清新靓丽的早晨
玲子的自信与性感
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有