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.


<h2>CPanel</h2>


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


<!--more-->


To set up a database using the MySQL Database Wizard:


<ol>


<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>


</ol>


<h2>Plesk</h2>


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





<h2>DirectAdmin</h2>


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





<h2>ISPConfig</h2>


<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

Share