Step By Step installation Guideline.
For MySQL - Install MySQL as appropriate for your operating system. There are a lot of documents on how to do this all over the internet and I'm not going to reiterate all of that here.
SECURITY TIP: Be sure to set a root password
Start your MySQL
Log in your MySQL database - For *nix operating systems and Windows from the command line: mysql -u root -p & hit enter
It will ask for the root password you set earlier.
You should get a prompt that says "mysql>"
Type in "CREATE DATABASE <mydatabase>;" <-- Note the semi-colon on the end which MUST be included on all statements to the database.
Do NOT include the < and >!
SECURITY TIP: Do not use the default database or user names or passwords included in the installation the document
Now you will need to make a user.
Type in "CREATE USER 'myuser'@'localhost/hostname' IDENTIFIED BY 'mysecurepassword';" & Hit enter
Type in "GRANT ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EXECUTE, INDEX, INSERT, LOCK TABLES, REFERENCES, SELECT, SHOW VIEW, UPDATE ON `mydatabase`.* TO 'myuser'@'localhost/myhostname' WITH GRANT OPTION;" & hit enter.
Type in "FLUSH PRIVILEGES;" <-- Note the semi colon
Your database is created, your user is created, your user has their password and their rights set. You should be ready to rumble.
In this step, the application wants to know, whether you are going to install this application as a fresh new copy or not. Select “New Installation” if you never used our application before.
The End User License Agreement appears during the process of installation. Please read this agreement carefully and print it for future reference. If you accept the terms of the End User License Agreement, you will proceed with the installation of the software and you will be bound by your obligations under the End User License Agreement.
If you do not accept the terms of the End User License Agreement, the installation process will stop and you may return the software within thirty (15) days of purchase.
Now the fun starts! Check the radio button next to “I accept the license agreement” and click “next”
The next step is to setup your database and provide our script the necessary information to access this database. If you have no idea how to create a database, you should refer my tutorial on setting up MySQL databases on Cpanel and setting up MySQL databases on DirectAdmin / cPANEL. You will need the host name of the database server (which is usually localhost), the database name, the username and password. As seen above, you will need to key in all those information before you click on Continue..
The important thing here is that you have to enter the correct database information.Use the port number, username, password, and database name which was created.
NOTE: If you do not see drop down menu here with your type of database (MySQL, PostgreSQL, etc.) your php PDO is either not installed or enabled. You may have to adjust your php.ini and restart your web server.
MySQL Note: You may also need to adjust your my.cnf to either allow for only localhost or adjust your settings here for the IP address. For MySQL the *default* port is 3306 but again, you need to check YOUR configuration file for YOUR server.
Let me go over a bit details to help understanding each fields :
The final step informs that you have just installed the application successfully and it generates a random password. Copy it and save it to somewhere.
SECURITY TIP: Log in and change your password right away. Use a strong password.