PHP supports three different extensions for connecting to MySQL databases: MySQL – the original, and now outdated, MySQL API MySQLi (MySQL Improved) – an improved MySQL interface, and the recommend method to use PDO MySQL – an alternative database abstraction method MySQL is deprecated as of PHP 5.5, and has been removed entirely from PHP […]
Category: General Information
How can I import my database?
Databases can be imported using the PHPMyAdmin feature in MyCP. To manage your databases with phpMyAdmin, log into myCP, click on MySQL Database at the top left, then click the phpMyAdmin link on the upper right hand side. Sometimes databases are too big to import using the PHPMyAdmin interface in MyCP. The import will […]
Can I connect to my MySQL database remotely?
No. In order to provide you with the highest performance and security, our GIP MySQL servers only allow connections from within the hosting environment.
What are my MySQL database limits?
GridLITE accounts may have a maximum of 5 mysql databases utilizing no more than 100mb collectively. GridPRO accounts may have a maximum of 25 mysql databases utilizing no more than 250mb collectively. GridMAX accounts may have unlimited databaeses utilizing no more than 250mb collectively.
What are my MySQL connection settings?
You will need the following in order to connect to your database: Your mysql server for GIP accounts is mysql.gip.superb.net The database name, found by looking at the entry under “Database” in the main MySQL screen in myCP. The database username which can be found by clicking “Users” for a particular database. The database password. […]
How do I login to phpMyAdmin to manage my databases?
To manage your databases with phpMyAdmin, log into myCP, click on MySQL Database at the top left, then click the phpMyAdmin link on the upper right hand side.
How do I delete a MySQL database?
In order to delete a MySQL database on your Grid Iron account, simply login to myCP, click on the “MySQL Databases” section and then click the “Delete” button next to the database you’d like to delete. Please note that all data in the database will be immediately and permanently erased.
How do I restrict a database user’s access?
To restrict the access of a database user: 1. Click MySQL Database in myCP. 2. Click the Users link for the database you wish to modify. 3. Change any options as desred using the radio buttons and check boxes. 4. Change the password if desired (not necessary to change other options). 5. Click “Submit” to […]
How do I reset my database password?
To reset your database password, click MySQL Database in myCP, then click the Users link for the appropriate database. On the following page, enter and confirm the new password.
How do I create a database?
To create a database, log in to myCP and click MySQL Database, then click the Create DB link on the following page.