Collections:
Selecting Other User's Database in MySQL
Can You Select Someone Else Database in MySQL?
✍: 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'
⇒ Execute SQL Statements in MySQL
⇐ Selecting an Existing Database in MySQL
2017-10-23, 1345🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...