- 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:
- MySQL database or MySQL dB wizard.
- Execution of SQL query at phpmyadmin - issuing grant privilege access
- MySQL database or MySQL dB wizard.
- 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.
- 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.
- 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
- 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.
No comments:
Post a Comment