MySQL Database

Setting up a new MySQL Database

Ultimate Locator utilizes a MySQL database backend. You must manually create your own database before you can install the software. Once you have your database created, our install script will setup everything else, including all the tables needed and the installation data. All you must do during the install is input your MySQL Database's Hostname, Database Name, Username and Password. The install script must have these inputs to locate your database and continue installation.

Typically if you have a rented server, such as from a hosting company, they will make is easy to create new mysql databases. Many hosting companies give you an online control panel, which may have a database manager built in. If so, you can use this tool to create your new database. If you do not have a control panel, there are other simple ways to create your database.

The easiest way to create mysql databases are with 3rd party database manager software. Such as phpMyAdmin or MySQL Administrator

Of course, you can always connect to your MySQL Host remotely, and follow the instructions below. You can visit W3Schools.com for easy instructions on creating your database with SQL.

How to Create a new MySQL database manually by hand...

a) Login to MySQL: Firstly, you need to login to the mysql interface, once you login you should have something like the following output:

> mysql -u root -p

Enter Password: [Enter your root password here]

b) Create Database: Assuming the database name is locator, user is admin, the host is localhost and the password is admin123, issue the following commands:

mysql > create database locator;

Query OK, 1 row affected (0.02 sec)

mysql > GRANT ALL PRIVILEGES ON locator.* TO admin@"%" IDENTIFIED BY 'admin123' WITH GRANT OPTION;

Query OK, 0 rows affected (0.01 sec)

mysql > exit

Bye >

These commands will create a new database named locator and assign the user admin to this database.

Additionally you can also use control panels like CPanel, Ensim or Plesk to create a database and assign users under it.

Check with your hosting company first to see if their hosting control panel offers you a way to create your own MySQL databases and users.

We Install... If you don't' feel comfortable installing the software, our team can do it for a nominal fee. Just contact support.

Page url: http://www.helpandmanual.com/help/index.html?mysql_database.htm