Welcome, Guest. [ Log In ]
'Goodies :: MySQL' Help Folder   Goodies :: MySQL
Search KBase


Related Links:
· How do I use the web panel to add extra plans and services to my account?

Top 5 in this Area:
1. What hostname do I use to connect to my database?
2. Is there an easier way to manage my database?
3. What username/password do I use to connect to my database?
4. How do I back up my database?
5. How long does it take for a new database to start working?

 
Goodies :: MySQL Description
View and manage your existing MySQL databases and users. You can also add new databases or delete existing ones. You can create as many MySQL users and Databases as you like on any of our plans.

We are currently running MySQL version 4.1.
Once you've created a MySQL database and a MySQL user, it's easy to access:

  • Log into your home machine (eg: venkman.dreamhost.com) as usual.
  • Once you're logged in, type the following at the shell prompt:

    mysql -h host -u user -p db

    where host is the MySQL Host Name, user is your MySQL Username, and db is your MySQL Database name.
  • Enter your MySQL password when you're prompted for it.
  • Start creating your tables and all that good stuff.
We also have a new feature!

You can now access all MySQL databases with us via a web interface (php MyAdmin)! Simply go to your database's host on the web! So if your MySQL host was mysql.mydomain.net, just point your browser to http://mysql.mydomain.net/!

Last updated: Jul 22, 2005.

Sub-Areas of Goodies :: MySQL
Question How do I back up my database?
To backup your MySQL database you can: Use phpMyAdmin and use the options there to dump the contents to a text file. From the shell, run this command: mysqldump --opt -u username -p ... (more)
Question How long does it take for a new database to start working?
Typically it'll take about 5-10 minutes after you create a database through our web panel before the new mysql hostname you've created will work. The actual database is created immediately, but you wo... (more)
Question Is there an easier way to manage my database?
Yes! Once you have a hostname and username/password for your database you can just connect to your databases via the php MyAdmin web interface. Simply go to your database's hostname using yo... (more)
Question What username/password do I use to connect to my database?
If you don't know what the username/password to use for your MySQL database is, then chances are that you never set one up. Go to the Goodies::MySQL section of the webpanel. Then click on "A... (more)
Question What hostname do I use to connect to my database?
Firstly: it is NOT "localhost" ! If you don't know what the hostname for your MySQL database is, then chances are that you never set one up. We know it's silly, but at least for right now you may... (more)