 Search the Knowledgebase |
 Browse by Category |
|
|
|
| View Articles by Category |
|
There are no sub categories
|
Database Questions
|
There were 13 articles found in this category:
 PHP5 and mysqli
Cpanel 11 is configured with php5 and mysqli
- max_allowed_packet setting for mysql
How do i get the max_allowed_packet for mysql changed ? Email support@midphase.com and one of our administrators can take care of this for you.
- How do I create a MySQL database?
1. Login to your control panel http://yourdomain.com/cpanel 2. Click on MySQL databases 3. Add database 4. Add database users 5. Add users to new database, with appropriate permissions. For plesk please refer to: http://midphasehelp.com/support/questions.php?questionid=714
- Do I use localhost or remotemysqlhost for my mysql connection ?
To see if your account is using localhost or remotemysql host: In cpanel 10 click on the “mysql databases” icon in the control panel, under access hosts you will see localhost or remotemysql host. In cpanel 11 click on phpmyadmin, click on your database name, your database host will ...
- How can I connect to our MySQL database from Dream Weaver?
Log into your cpanel account and click on "MySQL Databases" then under "Users" create a new user and password if you don't already have one you want to use. Then add that user to the database you wish to work with through Dreamweaver. At the bottom, add the “%” symbol to the “A ...
- How to reset your password for Advanced Guestbook.
To retrive the guestbook password select the guest book db in PHPMyAdmin and the table book_auth. While browsing it will show you the user name. run this sql command to change the password at the SQL query box in PHPMyAdmin update book_auth set password=PASSWORD('pass') where username='user'; wh ...
- How do I create a MySQL backup?
There are two ways to go about backing up your MySQL databases. 1)Use the backup utility in the control panel. (Easy way) 2)Manually backup using phpMyAdmin. To do this, follow these steps. ( Step 1: Login to your control panel http://yourdomain.com/cpanel Step 2: Click on MySQL databases Step ...
- How do I import a Database(PhpMyAdmin)
I have a backup of my database that I need to import/transfer to my new account. 1) Once you have your sql file you will need to log into your CPanel 2) In the CPanel you will find an Icon labeled MySQL Databases. **If you have not created the database you will need to do this Click HERE for ar ...
- What are the Basic Connection Settings for MySQL?
There are two different ways to connect to a MySQL database. Locally (from a script on the server, to the server), and Remotely (from a remote computer, using Shell, ODBC, or Navicat) Locally, the settings are: Hostname: localhost Username: username_dbuser Password: dbpassword db_name: username_ ...
- Mysql database and user naming syntax
Since we run a shared hosting environment, we have to uniquely identify your usernames to your account ONLY. We do this by attaching your system user name and an underscore("_") before all the databases and users YOU create. Example: I added a new database(or user) and I filled in the name: myd ...
- I can't log into MySQL from a remote computer using a MySQL admin tool(phpMyAdmin, Navicat, MySQLFront, MySQL-Admin, etc).
How to add yourself to the whitelist so that you can connect to mysql remotely. 1. Log into your control panel 1a. (ask tech support what your mysql server ip is) 2. Click on the 'Remote MySQL' icon under the databases category 3. Type % in the box 4. Click on 'Add Host' Your done! you should ...
- I would like to dump the Table Structure for my MySQL Database, but none of the data.
The command line option from SSH is: mysql -d -p database_name > file.sql Where "database_name" is the name of your database, and "file.sql" is the name of the file you would like to write the table structure to. It will prompt you for a password (-p) and this is required. Normally mysqldump ...
- How do I restore a MySQL database?
1. Login to your control panel http://yourdomain.com/cpanel 2. Click on MySQL databases 3. Scroll to the bottom and click on phpMyAdmin hyperlink 4. Click on the Database you want to restore then click on SQL 5. Click the Browse button and select your .sql file 6. Click 'Go' It may take long to ...
|
