i new working servers, , not able use sqlyog because not able connect server. when try use default values connect mysql (localhost, root, port 3306), "error no. 2003: can't connect mysql server on 'localhost' (0).
is there missing or have correct? trying create database.
sqlyog 1 way connect mysql database , interact it. other popular methods include mysql workbench, navicat, phpmyadmin, , others.
before can use of these, have first make sure mysql server running , accepting connections. didn't mention (or tag) whether running mysql on local machine, or operating system using.
a couple of common development environments lamp or wamp, "linux, apache, mysql, php" or "windows, apache, mysql, php" respectively. since tagged question php, i'll assume 1 of these appropriate. (for example you're using sqlyog on windows mysql server on linux.) (i'll presume ubuntu linux examples.)
on machine you've installed mysql (along other components), should able determine running state looking @ process list (ps aux in ubuntu, tasklist or task manager (gui) in windows).
you're looking mysqld (linux) or mysqld.exe (windows). if process isn't running, need start (linux/windows). if you're using wampserver (a popular windows all-in-one package), example, can in windows services "wampmysqld" or "wampmysqld64" , start service there.
if can't process start, may have configuration error. if process is running, may need check configuration way determine port running on, if it's not standard 3306.
the configuration file name , location can vary system , package, called "my.cnf" (linux) or "my.ini" (windows). check documentation on specific path.
once you've got service running, should able connect!
this default sqlyog connection dialog (at least in older version). defaults assume running mysql server on local machine (localhost), have user "root" no password, , default port 3306 used.
you'll need change of information differs on particular installation.
be aware if you're trying connect instance of mysql on machine, firewall may blocking port.
these steps should on right track.
Comments
Post a Comment