- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Open MySQL root access from all hosts?
To open root access from all hosts, we need to change the database to “mysql” with the help of USE command.
The syntax of USE command is as follows −
USE anyDatabasename;
Now, I will use predefined database ‘mysql’, which is as follows −
mysql> use mysql; Database changed
I have changed the database above. Here is the query to get root access from the entire host −
mysql> UPDATE user set host='%' where host='localhost'; Query OK, 6 rows affected (0.19 sec) Rows matched: 6 Changed: 6 Warnings: 0
Advertisements