Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can You Select Someone Else Database
Can You Select Someone Else Database? - MySQL FAQs - PHP Connections and Query Execution
✍: FYIcenter.com
If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will have no privilege to select other databases. If you try to access other databases, you will get an error. The following tutorial exercise shows you a guest user trying to access the system "mysql" database:
<?php $con = mysql_connect('localhost:8888', 'guest', 'pub'); if (mysql_select_db('mysql', $con)) { print("Database mysql selected.\n"); } else { print("Database selection failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
You will get something like this:
Database selection failed with error: 1044: Access denied for user 'guest'@'%' to database 'mysql'
2007-05-10, 4749👍, 0💬
Popular Posts:
What are the different storage classes in C? C has three types of storage: automatic, static and all...
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms all...
Once I have developed the COM wrapper do I have to still register the COM in registry? Yes.
How To Retrieve the Count of Updated Rows? - Oracle DBA FAQ - Working with Database Objects in PL/SQ...
What will happen in these three cases? if (a=0) { //somecode } if (a==0) { //do something } if (a===...