If you’re unsure of the correct service name on Windows, type net start to find it. On Linux, type sudo nano /etc/mysql//mysqld.cnf into a terminal or SSH window to edit this file using the nano editor (assuming your MySQL database is in the default location). To start, use your preferred console text editor to edit your MySQL database file.By this stage, this guide will assume you have already connected to the server, PC, or Mac hosting your mySQL database remotely and have console access.Īlternatively, you can configure a local MySQL server using an open terminal on Mac or Linux or a text editor on Windows. The first step in configuring MySQL to allow remote connections is to edit your MySQL configuration file. So, you will need to establish this connection first before you can proceed. In that case, you won’t be able to configure your MySQL database to allow remote connections directly unless your root mySQL account already allows remote connections. Suppose you don’t have remote access to your server via SSH (for example).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |