Well I'm following Kevin's article and I've installed PHP successfully, but not configured MySQL for Win32 (it works on my Linux box, and I'm running Win2k on this one).
Basically, I type the following into a console.
<BLOCKQUOTE><font size="1" face="Verdana, Arial">code/font><HR><pre>
C:\>cd mysql\bin
C:\MYSQL\BIN>mysqld-shareware
C:\MYSQL\BIN\mysqladmin -u root password "sitepoint"
MYSQLADMIN: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
C:\MYSQL\BIN>
[/code]
I telnet to localhost:3306 and it says connection refused, which means there is no other side waiting for a connection.
I didn't do anything out of the ordinary, like install MySQL in C:\winnt\system32 (or C:\windows\system32) and I'm out of ideas.
Anyone know what I did wrong?
(P.S. 'sitepoint' is not my password)
------------------
Quinn Slack
If Microsoft is the answer, it must be a bad question
C:\DOS C:\DOS\RUN \RUN\DOS\RUN
As I mentioned before I run MySQL on Win2k very well, I run it as a service though that starts with the machine.
My advice would be to try running it as a service
<BLOCKQUOTE><font size="1" face="Verdana, Arial">code/font><HR><pre>
C:\mysql\bin\mysqld-shareware --install
[/code]
now try connecting to it and see what it says, the only difference between your setup and mine (from what you have given) is that I renamed mysqld-shareware.exe to mysqld.exe before I ran it as a service.
OK thanks! I'm going to boot back into Windows right now to test it out.
Man am I having MySQL problems. Under Linux it doesn't work either...same error as on Windows I believe. It says I already have a server running on post 3306 (mysql port). Even though I rebooted to try it and did it immediatly after I logged on, and it isn't set to run or anything. And this isn't a trojan horse or a backdoor...I formatted yesterday and this is the first time I've been in Linux.
Well I'll post an update when I'm back in Windows.
------------------
Quinn Slack
If Microsoft is the answer, it must be a bad question
C:\DOS C:\DOS\RUN \RUN\DOS\RUN
Great, thanks. I gotta say though it isn't too fun always having this console entry in my taskbar. Probably if I buy MySQL then it won't be there but is it possible to run MySQLD-Shareware as a hidden task?
Oh and FYI I e-mailed you about this but in one place during installation there is a place where you tell us to type "msql [command]" and that could be a big prob for people who have both mSQL and MySQL.
Now it's working without any taskbar entry. I don't remember what I did but since this computer hasn't rebooted in months it won't be a problem.
In my task list there is an entry for mysql-shareware and it's taking up 11MB of RAM when it's idle, because if I remember someone wanted to know that stat. It is a nonissue for me as I have gobs of RAM.
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote/font><HR>Originally posted by d3v: Now it's working without any taskbar entry. I don't remember what I did but since this computer hasn't rebooted in months it won't be a problem.
In my task list there is an entry for mysql-shareware and it's taking up 11MB of RAM when it's idle, because if I remember someone wanted to know that stat. It is a nonissue for me as I have gobs of RAM.<HR></BLOCKQUOTE>
i guess you were faster than me..i had the same problem with mysql...i was about to email kevin yank, but then i saw your topic...thanks..btw this mySql rules, don't you agree?
Yep. What I like is that there is a common syntax between each SQL server (mSQL, Jet, SQL-Server, MySQL, Oracle, dBASE, etc.).
Also I found out what was wrong in Linux. For some reason or another even when I launched safe_mysqld console-independent it stayed as a sort of child of the console. Then when I kept following the instructions I had to ctrl-c MySQL outta there and therefore it quit.
/font><HR><pre>
Bookmarks