install Dolphin - use MySQL client create db

Dear friends,

I want to install Dolphin system on my own. To create the database, I plan to use MySQL client. In which part should I change in this script? If possible, please highlighted the word/s that easy for me to understand.

$ mysql -u adminusername -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON databasename.* TO "dolphinusername"@"hostname" IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> EXIT
Bye
$

MOHD AMIR

are you attempting to manage your database from SSH? if so and you are having to ask these types of questions, then there is going to be more problems for you as you trudge along. the best approach here would be to get something like mysql workbench or mysql administrator, and connect remotely to the server. not real sure why you would not install phpmyadmin, and manage the databases at least from that approach. because quite frankly, and no insult intended here, if you are in here asking what lines need to be edited in order for you to create a database on SSH, then two things are evident. you have no business in SSH, and you have no business trying to create a database from SSH.

essentially this forum is intended for help with the dolphin script. asking how to create a database is beyond the realms of dolphin script. i would also suggest looking into some of the sql online courses http://mysqlcourse.com is a free stand alone SQL server that teaches you at least the basics of the query language.

Dear DosDawg,

I just bought an Unlimited License. When I want to install the Dolphin to the server, dolphin system asked me to create the database. Instructions on how to create database is given, but I do not understand. One of the ways recommended by Boonex is run MySQL using the script provided. I scared to run the script because I worry about making mistakes during installation. That is why I write in this forum to ask anyone who knows the right ways.

Thanks,

MOHD AMIR

so do you have a VPS or dedicated server in a datacenter? if so do you have a control panel on that account? if so what is the control panel? you may not need to run the suggested method which is for more advanced users and not novices with little or no server knowledge.

DosDawg,

I decided not to use a dedicated server. Is it this system can run without using a dedicated / VPS server? The monthly subscription price is expensive for me.

So, how?

MOHD AMIR

so are you on shared hosting, or trying to run this from a home server? i need to know what you are working with in order to provide a precise answer. currently you have not really provided any information that is useful.

if you are on shared hosting, then your control panel (cPanel or any of the others) allows for database creation from the GUI. there is no need for you to worry about the instructions you have posted here, because if you are on shared hosting, in most cases, you have no access to ssh. so you would be forced to create the database via phpmyadmin or some other utility provided from the hosting service.

if you are trying to run a home server, again, you can install wampp and use phpmyadmin which is packaged with this app.

The following is the server hosting (shared) features which I subscribe.

Web/Email Space: 20 GB

Bandwidth Per Month: 50 GB

POP3/WebMail Account: Unlimited

Domain Per Account: 10

Subdomain: Unlimited

Dedicated IP: Shared

mySQL Database: Unlimited

Tomcat/JSP: Nil

Fantastico: Yes

Max CPU Consumption: 100MHz

Max Memory Consumption: 64MB

Web Based Control Panel: CPanel

Own Cgi-Bin: Yes

Real Audio/Video: HTTP Stream

Telnet/SSH: Nil

MX Record Modification: Yes

Server Side Includes (SSI): Yes

Secure Server Capability (SSL): Mid Linux Or Higher Packages (Dedicated IP)

Cron Jobs: Yes

Perl Version: 5.8.x

mySQL Version: 5.x.x

PHP Version: 5.2.x

PostgreSQL: 7.4.17

WAP/WML/Wireless: Yes

Password-Protected Directories: Yes

Operating System: Centos - Redhat Enterprise

Web Server Software: Apache 2.2.x

DosDawg, If you find the above characteristics is suitable for the Dolphin, I will hire the Dolphin's technical team to install the system for me. If not, I had to buy a dedicated server or VPS server. But between VPS & Dedicated servers, which one is better?

You have CPanel. You should be able to get to it from a web browser. www.yourdomain.com/cpanel. If not, your host can tell you how to get into it.

Cpanal has a database section that will allow you to easily create a database for dolphin.

Now. As for your server specs. Dolphin will not run well on those specs. Here are the major issues.

Web/Email Space: 20 GB - That is not enough space. Uploading of videos and music will quickly consume it.

Max CPU Consumption: 100MHz - Dolphin will quicky tank that. Not enough cpu power for dolphin.

Max Memory Consumption: 64MB - Dolphins min requirements is 128MB - 256MB is recommended. Not enough Memory.