Once you've got the service running, you should be able to connect! Check your documentation for help on the specific path. The configuration file name and location can vary by system and package, but generally it will be called "my.cnf" (Linux) or "my.ini" (Windows). If the process is running, you may need to check the configuration any way to determine what port it is running on, if it's not the standard 3306. If you can't get the process to start, you may have a configuration error. If you're using WampServer (a popular Windows all-in-one package), for example, you can also look in your Windows Services for "wampmysqld" or "wampmysqld64" and start the service there. If the process isn't running, you need to start it ( Linux/ Windows). You're looking for mysqld (Linux) or mysqld.exe (Windows). On the machine you've installed MySQL (along with any other components), you should be able to determine its running state by looking at your process list ( ps aux in Ubuntu, tasklist or Task Manager (GUI) in Windows). (For example you're using SQLyog on Windows but your MySQL server is on Linux.) (I'll presume Ubuntu for Linux examples.) Since you tagged your question php, I'll assume one of these is appropriate. You didn't mention (or tag) whether you are running MySQL on your local machine, or what operating system you are using.Ī couple of the most common development environments are LAMP or WAMP, for "Linux, Apache, MySQL, php" or "Windows, Apache, MySQL, php" respectively. Other popular methods include MySQL Workbench, Navicat, phpMyAdmin, and others.īefore you can use any of these, you have to first make sure your MySQL server is running and accepting connections. SQLyog is just one way to connect to a MySQL database and interact with it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |