MySQL has a built-in command to get a list of databases that can be accessed by the currently logged in user, and it is very easy to take this list and use it inside a PHP script.
First, let’s look at the command from inside the MySQL monitor ptogram. If you have any experience inside [...]
Many web based applications need to know what version of MySQL they are using. Fortunately MySQL has a built in command that will return the version as part of a query. Just enter the following command at the MySQL prompt and the server will return the version.
If you’re needing to get the version [...]
Some hosts give you the ability to login with a shell account through SSH. Even if this option is available, and on many hosts it is not, most of your admin activities will be more difficult since you will be using a command line interface rather than a web control panel like cPanel or [...]
While not as popular as cPanel or Plesk, many hosts are using the H-Sphere control panel. Fortunately it is very easy to create a MySQL database through the H-Sphere interface.
Login and click the icon
The first step after logging in to your H-Sphere account is to click on the MySQL server icon.
Creating the database
Clicking on [...]
One of the first steps you need to take before installing any database driven web package is to create a database, and most use the open source MySQL server.
For this tutorial I am going to be using cPanel because that’s what I’ve used most often. Other hosting control panels are similar.
MySQL Control Panel
Log into [...]