Collapse All Expand All

Configuring MySQL For Network Access

By default, the root user in MySQL will not be allowed access from remote machines. The easiest way to allow remote access is to grant access to another user, and then specify that user in the database login on the remote PC.

Here are the steps to do this:      

1. Run the MySQL command-line client on the MySQL server PC. This is in Start->All Programs->MySQL->MySQL Server x.xx->Command Line Client.
2. Type use dbname; and press enter (where dbname is the name of the database; usually jpegger or ezcash)
3. Type grant all on * to username identified by ‘password’; and press enter (where username and password are the desired username and password)
4. Type exit and press return.

That should configure the specified database to allow remote access by the specified user.

 

 

---

This website and its content is copyright of ScrapDragon, LLC - © ScrapDragon, LLC 2018. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: You may copy the content to individual third parties for their personal use, but only if you acknowledge the website as the source of the material. You may not, except with our express written permission, distribute or commercially exploit the content. Nor may you transmit it or store it in any other website or other form of electronic retrieval system.