If you want to install Open eShop, besides the required PHP, you will need a MySQL server with a database and a user name.

100% of managed hostings come with some short of automation for this. If yours doesn't, check our <a href="http://open-eshop.com/hosting/">hosting</a> offer.

To make your life easier I am just collecting some videos done from users explaining this process in different panels.


<iframe src="//www.youtube.com/embed/YbIn--iNmKE" width="640" height="360" allowfullscreen="" frameborder="0"></iframe>


To set up a database using the MySQL Database Wizard:


<li>In the New Database field, enter a name for the database.</li>

<li>Click Next Step.</li>

<li>In the Username field, enter a name for the user allowed to manage the database.</li>

<li>In the Password field, type the user’s password.</li>

<li>The password must be 7 letters or shorter.</li>

<li>For help generating a strong password, click the Password Generator button.</li>

<li>Retype the password in the Password (Again) field.</li>

<li>Click Create User.</li>

<li>Select the privileges you wish to grant the user, or select ALL PRIVILEGES.</li>

<li>Click Next Step.</li>

<li>Next, cPanel will display a message stating that the database and user account were successfully set up.</li>



<iframe width="640" height="360" src="//www.youtube.com/embed/ZTEc5epNvI0" frameborder="0" allowfullscreen></iframe>


<iframe width="640" height="360" src="//www.youtube.com/embed/7QGVQau-gCI" frameborder="0" allowfullscreen></iframe>


<iframe width="640" height="360" src="//www.youtube.com/embed/6XosdMzU2pQ" frameborder="0" allowfullscreen></iframe>

<h2>MySQL (advanced users)</h2>

<strong>Step 1:</strong> Login to MySQL ( you will need an account )

<pre>user@server:~$ mysql -u mysql_user -p

Enter password:</pre>

<strong>Step 2:</strong> Create the Database

<pre>mysql &gt; create database db_name;</pre>

<strong>Step 3:</strong> Verify that it’s there

<pre>mysql &gt; show databases;</pre>

<strong>Step 4:</strong> Create the User

<pre>mysql &gt; create user db_user;</pre>

<strong>Step 5:</strong> Grant privileges while assigning the password

<pre>mysql &gt; grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';</pre>

*Note: The <em>localhost</em> field usually doesn’t have to be edited, but you can set it to the specific address.

The above example grants <em>all</em> privileges, obviously. But you will likely want to limit privileges under many circumstances. These parameters include <em>select</em>, <em>insert</em>, and <em>delete</em>.

Choose all that apply and separate by comma, thusly:

<pre>mysql &gt; grant select, insert, delete on db_name.* to 'db_user'@'localhost' identified by 'db_password';</pre>

comments powered by Disqus