1.修改phpMyAdmin的設定檔config.inc.php
-設定 phpMyAdmin 認證模式:$cfg['Servers'][$i]['auth_type'] = 'http';
-改為http表示透過瀏覽器輸入帳號及密碼進行MySQL的認證,並把$cfg['Servers'][$i]['user'] &['password']=''; <===原設定拿掉
-若用config,則需要將密碼寫入檔案,設定如下
$cfg['Servers'][$i]['user'] = 'rdcenter';
$cfg['Servers'][$i]['password'] = 'rdxxxx';
2.新增mysql user,並給予權限
-改為http表示透過瀏覽器輸入帳號及密碼進行MySQL的認證,並把$cfg['Servers'][$i]['user'] &['password']=''; <===原設定拿掉
-若用config,則需要將密碼寫入檔案,設定如下
$cfg['Servers'][$i]['user'] = 'rdcenter';
$cfg['Servers'][$i]['password'] = 'rdxxxx';
2.新增mysql user,並給予權限
mysql> grant all privileges on net00db.* to net00@localhost IDENTIFIED BY '12345678' ;
mysql> grant select on TotalClickBoard.* to cti@localhost IDENTIFIED BY '16318448' ;
mysql> FLUSH PRIVILEGES ;
沒有留言:
張貼留言