Difference between revisions of "How to access MySQL database via WEB"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Since MOR v0.7 phpmyadmin directory is restricted from web access.
To access MySQL database via WEB you need to do:
To access MySQL database via WEB you need to do:
Login via ssh to your MOR GUI server and execute:
Login via ssh to your MOR GUI server and execute:
Line 4: Line 6:
And you must see something like this:
And you must see something like this:
   Login and Password from phpMyAdmin system: admin YOURPASSWORD
   Login and Password from phpMyAdmin system: admin YOURPASSWORD
Now go to http://GUIipAddress/phpmyadmin and enter correct details which you have got from /root/phpMyAdminPassword file. Then login using your regular details from mysql. (Mostly 'mor/mor' or just 'root' without password will help you to access phpmyadmin web page where you can manage your databases). '''Be very carefull when changing something in database, its good idea to whole database backup before making any changes.'''
Now go to http://'''IP ADDRESS OF YOUR WEB SERVER'''/mordbadmin (for example http://123.123.123.123/mordbadmin)
and enter correct details which you have got from /root/phpMyAdminPassword file.  
 
Then login using your regular details from mysql. (Mostly 'mor/mor' or just 'root' without password will help you to access phpmyadmin web page where you can manage your databases).  
 
'''Be very careful when changing something in database, its good idea to make whole database backup before making any changes.'''
 
BETTER IF YOU DO NOT CHANGE ANYTHING IN DB AT ALL!
 
 
A real world example how to obtain phpmyadmin password from system:
 
[[Image:ppp.png]]

Latest revision as of 11:35, 23 February 2015

Since MOR v0.7 phpmyadmin directory is restricted from web access.

To access MySQL database via WEB you need to do: Login via ssh to your MOR GUI server and execute:

  cat /root/phpMyAdminPassword

And you must see something like this:

  Login and Password from phpMyAdmin system: admin YOURPASSWORD

Now go to http://IP ADDRESS OF YOUR WEB SERVER/mordbadmin (for example http://123.123.123.123/mordbadmin) and enter correct details which you have got from /root/phpMyAdminPassword file.

Then login using your regular details from mysql. (Mostly 'mor/mor' or just 'root' without password will help you to access phpmyadmin web page where you can manage your databases).

Be very careful when changing something in database, its good idea to make whole database backup before making any changes.

BETTER IF YOU DO NOT CHANGE ANYTHING IN DB AT ALL!


A real world example how to obtain phpmyadmin password from system:

Ppp.png