Tips on MySQL Connections

[Lorddraco98]

I seem to be having problems with the MySQL database and vB connecting to it. I'm running on APache 3.2.2 PHP 4.1.1, MySQL 3x(latest) and win 98. Anyone have tips for not getting these connection errors to the database. I tried the host set on 127.0.0.1 and localhost

[JamesUS]

It would help to know what the errors actually are :)

[Lorddraco98]

sorry

Warning: Can't connect to MySQL server on 'localhost' (10055) in c:\program files\apache group\apache\htdocs\forums\admin\db_mysql.php on line 38




There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.



that's the error i get a lot.

[Lorddraco98]

could it possibly be a win 98 problem?? any help would be appreciated!!

[eva2000]

can you post a link to your forums which is having this error ?

[Lorddraco98]

http://www.thedigitalsector.2y.net:2000/forums
it's up 8:00AM-6:00PM EST for now because of server probs.

[scoutt]

is mysql running? also check to see if you have the correct db name and stuff like that. I have no problems with mysql/apache/win98 all running at the sametime.

[Lorddraco98]

it now says when i goto databases and then to create or even to check MySQL that the server is not running(mySql). That's really odd. how would i turn the MySQL server on. It's always been on before :confused:

[scoutt]

I have to manually turn MySql on everytime I use it. I am using it for testing not for people to connect to. so mine might be setup different than yours.

[Lorddraco98]

any idea on how to start it up though??

[scoutt]

the way I start mine is I goto a dos prompt and work my way to c:\mysql\bin and then type mysql to start. it then leaves a dos box open all the time.

[Lorddraco98]

I'll try that. I tried the mysqld command and it started without errors, but first i had to disable the INNODB from starting up. Does vB require the InnoDB to run in MySQL??

[eva2000]

Originally posted by Lorddraco98
I'll try that. I tried the mysqld command and it started without errors, but first i had to disable the INNODB from starting up. Does vB require the InnoDB to run in MySQL?? no if you have not converted your mysql database types to innobase you do not need innobase to start up at all

[nuno]

huh?
Explorer
c:\mysql\bin\mysqladmin :)

[Lorddraco98]

odd. i tried the \mysql and it gives this error: Error 2003: Cannot connect to MySQL server on localhost (10061)
Any ideas??

[eva2000]

nuno wrong command......

to start mysql on windows 95/98

in MS-DOS window and type:

C:\> C:\mysql\bin\mysqld

to stop mysql type

C:\> C:\mysql\bin\mysqladmin -u root shutdown

[Lorddraco98]

I've done that, but obviously something is wrong and it isn't connecting. Beucase when I try to use any of the \mysqladmin commands it says cannnot connect to mysql server, make sure the server is running and on port 3306 and try to do a telnet to check the connection. I did a telnet and it says cannot connect to localhost. This is really making me mad. Any ideas??

[eva2000]

you've tried all of http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html ?

[Lorddraco98]

Yeah :(

[nuno]

u sure eva?
i cant remember exactly, but i think that mysqladmin starts MySQL on w2K platforms.
I may be wrong, but........

Have you installed ODBC?

[eva2000]

might find your answer at http://www.mysql.com/doc/W/i/Windows.html

[nuno]

oh i c
he's running win98 :rolleyes: