jump to navigation

This is NOT the official website of AvantBiz Consulting Limitd but just some casual discussions about various topics. Please visit www.avantbiz.com if you need our professional services.

Setup a remote connection to MySQL January 19, 2007

Posted by admin in : Computer 電腦,Linux , add a comment

To remotely connect to your MySQL databases, you must have an I.P.-based account. Login to your control panel and click on the side menu “ValueApps” then the “Database” tab. If you have not installed MySQL, click on “MySQL Database” under Available ValueApps. If you have already installed MySQL, click on “MySQLs” under Installed ValueApps. Check the box “TCP/IP Connection”. Now login to your account via SSH.

Use the MySQL monitor to grant privileges.

Start the MySQL monitor with this command:

mysql

or:
/usr/local/mysql/bin/mysql

Your shell prompt should now look like this:
mysql>

Run this command:

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY “PASSWORD”;

USERNAME is the username that you would like to create.
IP is the public IP address of your remote connection. See examples
PASSWORD is the password you would like to use for this username.
You now must flush MySQL’s privileges. Run this command:

FLUSH PRIVILEGES;

Run this command to exit MySQL:

exit;
 



Linux: Change file owner November 4, 2006

Posted by klyuen in : Computer 電腦,Linux , add a comment

chown newusername *.*
chown newusername *



Use .htaccess to restrict access to web pages October 16, 2006

Posted by klyuen in : Computer 電腦,Linux,Web 網頁 , add a comment

This document demonstrates the use .htaccess to restrict access to web documents by user and password.

(more…)