MySQL Maintenance

Set up and manage your mySQL data bases from this section

 

Databases:
database_mainsys
Users in mainsys
database_user (Privileges: ALL PRIVILEGES)
Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:database_mainsys:localhost","database_user","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "database_user", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database_mainsys");

database_news
Users in news
database_user2 (Privileges: ALL PRIVILEGES)
Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:database_news:localhost","database_user2","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "database_user2", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database_news");

User: Db:
Privileges: ALL ALTER CREATE TEMPORARY TABLES CREATE DELETE DROP SELECT INSERT UPDATE REFERENCES INDEX LOCK TABLES


Db:
Users:
database_user
database_user2
UserName:
Password:

Access Hosts:
localhost
Host (% wildcard is allowed):

phpMyAdmin
You can use phpMyAdmin to administer your MySQL databases in a web based environment.
 

 

Close Window