CentOS-連線MySQL的GUI工具

MySQL放置處

• #/var/lib/mysql --->MySQL的db放置處
• #/var/log/mysql.log --->放log
  
• #/var/run/mysqld --->process ID

登入mysql

• [root@localhost ~]# mysql -u root -p

顯示engines;

• mysql> show engines;
  

建立帳號jack管理phpbb3的db

• mysql> grant all on phpbb3.* to jack@'%' identified by 'abc123';
  
• Query OK, 0 rows affected (0.00 sec)

用jack登入

• [root@localhost ~]# mysql -u jack -p

使用db:phpbb3

• mysql> use phpbb3;

顯示phpbb3所有的table

• mysql> show tables;

離開

• mysql> quit

 ======================================
利用此工具連線MySQL

Download
mysql-gui-tools-5.0-r17-win32.msi