FAQ – PHP & MySQL
- What is MySQL?
- After I install osCommerce I get a sessions directory error?
- Can I install phpMyAdmin?
- Can you disable or turn off php Safe Mode?
- How do I create a MySQL database?
- What is MySql hostname?
- My PHP program tells me it can’t access the database and gives errors?
- How do I connect to my database from my pc or a remote computer?
- What version of php and mysql are you running?
A - MySQL is the most popular Open Source SQL Database system. A database is a structured collection of data. MySQL allows you to quickly access, edit and add to the database.
A - Set this in both your admin/includes/configure.php and catalog/includes/configure.php files:
A - No, users are not allowed to install their own versions of phpMyAdmin.
Instead, this program is offered through the CPanel for you to use. PhpMyAdmin is at the bottom of the MySQL Databases section in the CPanel.
A - No, it cannot be disabled. All the servers have php safe mode enabled due to security reasons.
A - Login to your cPanel then goto –> MySQL Databases –> Add a new database, then create a user. Then all you need to do is add the user into the database.
A - Your Hostname is: localhost
A - When you create your MySQL database, first you need create a database by giving it a name. Then you create a user by entering a username and password. For best results keep your database name, database username, and database password at no fewer than 6 and no more than 7 letters or numbers. Then you make sure that you have added the user to the database.
In your script, your database name and your database username must be prefaced by your hosting account username_. Your password, however, stands alone without any prefaces.
For example: If your hosting account username is “blue5″, your database name is “testdb”, your database username is “dbuser”, and your database password is “passwd”, this is how you need to put them in your script:
database server should be: localhost
database name should be written as: dothehos_testdb
database username should be written as: dothehos_dbuser
database password should be written simply as: passwd
A - We do not allow database connections to the MySQL server from remote computers. We closed our database server remote access port due to security reasons.
So unfortunately you cannot connect from ODBC/JDBC/Macromedia DreamWeaver applications.
You have to connect to your databases from your website through scripts or the cpanel phpmyadmin tool for managing your databases.
This is the reason that our MySQL server name is always: localhost
A - This information can be seen after logging in to your cPanel under the General server information section on the left. PHP and MySQL will be upgraded from our cpanel servers if there are any stable versions available.