Bluehost Web Hosting Help

Sort by

Help Content Tagged Mysql - 40 results RSS


How to Create and Delete MySQL Databases and Users

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.

How To Manage Databases With Command Line SSH

This article will instruct you how to export a database from the command line (SSH).

Import a MySQL Database using phpMyAdmin

How do I import a backup of my database (.sql file) using phpMyAdmin?

How Import Databases Using Command Line SSH

This article will instruct you how to import a database from the command line (SSH).

MySQL Repair and Optimize Tables in phpMyAdmin

How to repair and optimize your database using phpMyAdmin:

How to Backup a MySQL Database

How do I create a MySQL backup?

MySQL Import and Export

I need to Export or Import a MySQL database

CPU Performance Issues

What is CPU Protection

MySQL Database Restore

How to Restore your MySQL Database?

Managing Your DB Using phpmyadmin

A repository of information on how you can manage your database by using the phpMyAdmin interface.

MySQL Database and user name convention

I cannot connect to my database locally or remotely, do I have the correct server, username and password?

MySQL Version

What version of MySQL are you running?

How To Rename Database Tables in PHPMyAdmin

This article will show you how to rename a database table in phpMyAdmin.

MySQL Database Access Outside of cPanel

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password?

MySQL Connection Strings

This article will describe connections strings, what they are used for, and give examples.

MySQL dump of tables only no data

I would like to dump the Table Structure for my MySQL Database, but none of the data.

Backup all MySQL databases using the Site Backup & Restore tool

How to backup all of your MySQL databases using the Site Backup & Restore tool

Connecting to your MySQL DB from Dreamweaver

How can I connect to our MySQL database from Dreamweaver?

Local MySQL Connection Blocked To Server

I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.Bluehost.com' is blocked because of many connection errors; unblock with 'mysqlad

How To Reset MySQL Database User & Password

This article will explain how to change the password for a database in the event that the original password is lost.

Restore MySQL databases using the Site Backup & Restore tool

How to restore MySQL databases using the Site Backup & Restore tool

Setting a Password for the Main MySQL User

I am prompted to set a new MySQL password. What does this mean and how do I change it?

MySQL Database Compatibility

How do I make my MySQL database compatible with the version you provide?

How To Copy A Database Using PHPMyAdmin

A guide to duplicating a MySQL database using phpMyAdmin

Managing Databases with Applications

This article will go over different application available for remote connection to your databases.

Connecting Scripts to MySQL Databases

This article will explain how to connect your scripts to your MySQL databases.

Optimizing MySQL: Queries and Indexes Article 3 of 4

Optimizing MySQL: Queries and Indexes Article 3 of 4 Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example o

Optimizing MySQL: Queries and Indexes Article 1 of 4

Optimizing MySQL: Queries and Indexes Article 1 of 4 Courtesy of: Ian Gilfillan Badly defined or non-existent indexes are one of the primary reasons for poor performance, understanding and then fixing

Optimizing MySQL: Queries and Indexes Article 4 of 4

Optimizing MySQL: Queries and Indexes Article 4 of 4 Courtesy of:Ian Gilfillan Most systems need to be highly optimized for selects - take a news site which performs millions of queries per day, but w

Character sets in PHP

How to Set different character sets with PHP and HTML to display correctly.

Adding a column to a db table in phpMyAdmin

Instructions on adding a column to your database in phpMyAdmin

Modifying table columns - phpMyAdmin

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin

How To Run SQL Queries in PHPMyAdmin

A guide on performing a standard SQL query using the phpMyAdmin interface

Dropping columns from a database table using PhpMyAdmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin

Optimizing MySQL: Queries and Indexes Article 2 of 4

Optimizing MySQL: Queries and Indexes Article 2 of 4 Courtesy of: Ian Gilfillan Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table w

Searching a database in PhpMyAdmin

Step by step directions on how you can search your database using phpMyAdmin

Change a MySQL Users Password

This article will explain how to change or reset the password for a MySQL user.

MySQL Error Messages

This article will show a few MySQL errors along with explanations as to why they might be occurring.

How to Add Tables to a DB in PhpMyAdmin

Guidance on adding tables to your mySQL database in phpMyAdmin

MySQL Var Types

A refrence defining the various mySQL variable types