| Category: MySQL |
| Subject: None |
|
| |
| |
| Questions |
| |
| Where can I go to see the MySQL log file?
|
The MySQL log file is located at:
/usr/local/mysql/var/(your-username).log
|
| -- Updated: 02/05/03 |
|
| How to I access the MySQL server when logged in with SSH?
|
Follow the steps below:
- Log into your account using a Telnet or SSH program. Only the site's main user has SHELL access to the server.
- Change directory to the /usr/local/mysql/bin/ directory.
Example:
sh-2.05$ cd /usr/local/mysql/bin/
- You can then run the mysql command, along with all MySQL-related commands on the server.
Example:
sh-2.05$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.49-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Note: that when the MySQL Database Value App is installed from the Domain Directory Control Panel, the root MySQL user is automatically created. You have root access to your own MySQL server.
Note: this feature is not available on all accounts. |
| -- Updated: 02/05/03 |
|
| How do I manage MySQL databases?
|
Follow the steps below:
- Login to the site manager.
- Click 'ValueApps'.
- Install the MySQL ValueApp.
If you want to be able to remotely connect to the database, click TCP/IP connection.
- Install the 'PHPMyAdmin' ValueApp.
- Click on the link for the PHPMyAdmin ValueApp once it's installed and login.
From here you will have full control over your databases.
|
| -- Updated: 02/05/03 |
|