Setting up MySQL database

Setting up a MySQL database

Under PHPMyAdmin

	Logon to your PHPMyAdmin page. It depends on the version number how this page will look. Here we use the latest stable version (2.6.2). See http://www.phpmyadmin.net/ for documentation. Under the section ‘Create new database' fill in a name for your database in the text box. The jumpmenu ‘Collate' gives you the option to specify a certain characterset (default is UTF-8). Click on ‘Create' and you are finished. The user name for your database is usually the same as the name you have given the database.
	BTW: some hosts do not let you create a database directly with PHPMyAdmin, but instead offer you a special page on the server of your host to do so. When created, you can later edit this database with PHPMyAdmin. Below is a screenshot of such a page on the host SecureNet (http://www.lenoren.us/). Ask your host for information if you do not know how to set up a MySQL database on their server.

Under cPanel (V10.2)

	First, go to the section entitled "MySQL Databases". There you can control adding new as well as deleting and reparing existing databases.
	Next, add a database such as in this example.
	The database requires a user to have all privileges on the database such as shown in the screenshot on the left.
	At the end of the process, you should see your database together with the user. Type in the exact name as seen on this page into the first page of the transLucid automatic installation (here ‘theandb_translucid').