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, 4642👍, 0💬
Popular Posts:
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
How can I include comments in HTML? An HTML comment begins with "<!--", ends with "-->...
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how...
Which is the best place to store ConnectionString in Dot Net Projects? I am about to deploy my first...
What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...