Need Help Configuring MySQL

[travist]

RHEL 4/MySQL 5.0.2/Apache2/PHP4.39


I have installed the newest MySQL server, client and administrator, yet when I run the install page form the browser it still says that mySQL is not available. What am I doing wrong?


Do I need to configure MySQL more? I am really new to MySQl so any idiots steps would be great.

Thanks!

Travis

[travist]

Just used the latst SugerCRM and still get Not Available next to Mysql Database. Help....

[ajl]

Are you running MySQL and SugarCRM on the same host?
Have you confirmed that MySQL is actually running? Try the following command.

# ./mysqladmin -u root -p version
Enter password:
./mysqladmin Ver 8.41 Distrib 4.1.12, for sun-solaris2.8 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.12-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 41 days 23 hours 34 min 58 sec

Threads: 11 Questions: 578959 Slow queries: 0 Opens: 27367 Flush tables: 1 Open tables: 64 Queries per second avg: 0.160
#

You may also want to check out the pre-bundled installation packages.

http://www.sugarforge.org/frs/?group_id=79

Good Luck.
-Tony

[rliebscher]

hi travis,

i think, your mysql works just fine.

the thing, you have to do, is to activate the mysql-driver for php.
open your php.ini in editor and search for the following entry:
;extension=php_mysql.dll
just remove the ";" to uncomment and activate this.

the same for this entry
extension=php_mysqli.dll
If it doesn't exist, just paste it in from here.

Then you have to restart your webserver and it should work.

If you have more problems, please see also this thread:
http://www.sugarcrm.com/forums/showthread.php?t=8261

Greetings
Ronny