Current problems of cpanel seringgit.com to solve

1. The phpmyadmin does not show the menu 'Privilege' where i can add/edit/delete any MySql users. This is where i can add new user for my drupal dB and assign appropriate privilege to him. Perhaps i can try via the following method:
   
   
   
   1. MySQL database or MySQL dB wizard.
      
   2. Execution of SQL query at phpmyadmin - issuing grant privilege access
      
   
   
   
2. cpanel phpmyadmin does not show any mysql dB where i can check the available users inside table user. So there should be another way around for me to ensure a particular username can be created and he has access to my new drupal dB.
   
   
3. The settings.php at site/all/default/ shows a preset values for database name, username and password where they do not tally with the configuration of MySQL at cpanel. This happens when i run drupal script for installation process. Because of this i need to manually change the settings.php value and upload back to the hosting.
   
   
4. Perhaps one way to verify this is to install Wordpress and see whether this problem arises or not. I can also check how does the new username assigned to wordpress dB is contructed in my seringgit.com hosting.
   
   

Trouble-shooting attempts

1. I managed to assign one particular user (i've just created via cpanel) using MySQL database cpanel web-application to my drupal dB. So i think my mistake was, i tried to use phpmyadmin to do this task, but what i should do was to use MysSQL database icon in cpanel.
   
   The values set in settings.php are as below:
   
   Then when i re-run drupal script, another different problem occurs.
   
   
   
   

Problem running drupal script via Fantastico.

Till now i've able to install the complete drupal script but when i want to run & install drupal on my hosting, it failed. Partly because the script does not understand the auto created username seringgi_drupal (example ya) and database seringgi_drpl1 (also example ya) in file settings.php. So, what i need to do right now is to manually change the name and try to setup the valid MysQL username that has all GRANTED access to this particular table.


Well, i still need to refer to the guru-drupal-doc page -> "Installation Guide" along the way of trouble-shooting this problem. I hope i will be able to solve this by today.


The link is http://drupal.org/documentation/install/create-database

.

2nd attempt of Creating MySQL dB successful

I know already what is wrong with my 1st attempt of creating Mysql db. instead of applying the 'mysqladmin' at the DOS prompt, i wrongly type it inside the MySQL client and executed it, and that's why it resulted error message. The followings are the correct steps.



The complete doc and steps can be accessed from drupal "installation guidelines" as follows:
http://drupal.org/documentation/install/create-database

The link is http://drupal.org/documentation/install/create-database
.

First attempt creating MySql dB Failed

This was my first attempt of creating MySQL database using a command line via MySql client. It's like a DOS and usually for those who do not like command lines will definitely try to avoid using this method. Anyway i'm just trying a different more challenging method instead of using phpmyadmin GUI. And as expected it had failed.



The complete doc and steps can be accessed from drupal "installation guidelines" as follows:
http://drupal.org/documentation/install/create-database

.