Programming Forums > Web Development and Design > PHP

tempest · Feb 10th, 2005, 8:32 PM

(Assuming Windows) From command prompt, go to your MySQL bin directory and type "mysql.exe", if it opens to a "mysql> " screen then you're fine... if it errors out then you're not.

ArchAngel · Feb 10th, 2005, 9:04 PM

tempest - I did that and it gave me the error 2003 again.

BlazingWolf - Dunno how to, by looking for the MySQL module, do you mean setting PHP.ini to recognize it? I'd need someone to explain how.

tempest · Feb 10th, 2005, 9:12 PM

You need to start MySQL, it's not running... tell me the files you have in your MySQL bin directories and i'll tell you which one to execute to start your MySQL server.

Ooble · Feb 11th, 2005, 6:35 AM

MySQL is running - mysql.exe works. What you need to do is go into php.ini, and find the lines mentioning mysql.so and mysqli.so. Remove the semicolon ( ; ) from the beginning of these lines, save, and restart Apache.

ArchAngel · Feb 11th, 2005, 7:19 AM

I found the MySQLI and MySQL sections, but where exactly do you want me to remove the semicolons?

(Toggle Plain Text)

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

[MySQLI]

; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_password =

; Allow or prevent reconnect
mysqli.reconnect = Off

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

[MySQLI]

; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_password =

; Allow or prevent reconnect
mysqli.reconnect = Off

I uploaded this to a site and searched through the webpage, there aren't any lines with MySQL.so or MySQLI.so

Quote:

Originally Posted by temp

You need to start MySQL, it's not running... tell me the files you have in your MySQL bin directories and i'll tell you which one to execute to start your MySQL server.

(Toggle Plain Text)

comp-err.exe
vygwinb19.dll
isamchk.exe
libmySQL.dll
my_print_defaults.exe
myisam_ftdump.exe
myisamchk.exe
myisamlog.exe
myisampack.exe
mysql.exe
mysqladmin.exe
mysqlbinlog.exe
mysqlc.exe
mysqlcheck.exe
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
mysqld-nt.exe
mysqld-opt.exe
mysqldump.exe
mysqlimport.exe
mysqlshow.exe
mysqlwatch.exe
pack_isam.exe
perror.exe
replace.exe
winmyadmin.cnt
winmysqladmin.exe
winmysqladmin.GID
WINMYSQLADMIN.HLP

Ooble · Feb 12th, 2005, 8:48 AM

Not that bit - it's the bit packed full of DLLs. If it's not there already, add:

(Toggle Plain Text)

extension=php_mysql.dll
extension=php_mysql.dll

to php.ini. If it is, remove the semicolons from the beginning of the lines.

And make sure your PHP directory (usually C:\PHP) is in the PATH environment variable.

ArchAngel · Feb 12th, 2005, 9:19 AM

I found that line, is that the only line I need to remove the semicolon from?
I remove the semicolon from the beginning of that line, saved the .ini, replaced the one in the windows folder iwth it, and tried running MySQL, but with no avail.

BTW, I'm not using a webserver (at least that I know of).

Ooble · Feb 12th, 2005, 6:25 PM

Sorry - you need to remove it from:

(Toggle Plain Text)

extension=php_mysqli.dll

as well. Note the "i".

ArchAngel · Feb 12th, 2005, 6:51 PM

I didn't find a mysqli.dll in the php.ini, so I added one, but it still gave me the error.
Also, if I do: "net start mysql", in prompt, it says the service was succesfully started,
is that relevant at all?

Quote:

And make sure your PHP directory (usually C:\PHP) is in the PATH environment variable.

What is the exact name of that variable?

My php.ini

Ooble · Feb 13th, 2005, 7:54 AM

Go into System -> Advanced -> Environment Variables (I think). In the System box, scroll down till you find PATH, and edit it so it has your PHP path at the end (paths are separated by semicolons).

Or you could just type at the DOS prompt:

(Toggle Plain Text)

SET PATH=%PATH%;C:\PHP

Feb 10th, 2005, 8:32 PM	#11
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 5	(Assuming Windows) From command prompt, go to your MySQL bin directory and type "mysql.exe", if it opens to a "mysql> " screen then you're fine... if it errors out then you're not. __________________

Feb 10th, 2005, 9:04 PM	#12
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	tempest - I did that and it gave me the error 2003 again. BlazingWolf - Dunno how to, by looking for the MySQL module, do you mean setting PHP.ini to recognize it? I'd need someone to explain how. __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home.

Feb 10th, 2005, 9:12 PM	#13
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 5	You need to start MySQL, it's not running... tell me the files you have in your MySQL bin directories and i'll tell you which one to execute to start your MySQL server. __________________

Feb 11th, 2005, 6:35 AM	#14
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	MySQL is running - mysql.exe works. What you need to do is go into php.ini, and find the lines mentioning mysql.so and mysqli.so. Remove the semicolon ( ; ) from the beginning of these lines, save, and restart Apache. __________________ Me :: You :: Them

Feb 12th, 2005, 8:48 AM	#16
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Not that bit - it's the bit packed full of DLLs. If it's not there already, add: (Toggle Plain Text) extension=php_mysql.dll extension=php_mysql.dll extension=php_mysql.dll extension=php_mysql.dll to php.ini. If it is, remove the semicolons from the beginning of the lines. And make sure your PHP directory (usually C:\PHP) is in the PATH environment variable. __________________ Me :: You :: Them

Feb 12th, 2005, 9:19 AM	#17
ArchAngel Programmer Join Date: Jan 2005 Location: I could be anywhere, even Indiana Posts: 34 Rep Power: 0	I found that line, is that the only line I need to remove the semicolon from? I remove the semicolon from the beginning of that line, saved the .ini, replaced the one in the windows folder iwth it, and tried running MySQL, but with no avail. BTW, I'm not using a webserver (at least that I know of). __________________ People say I'm crazy, but I have the heart of a little boy. It's in my desk at home.

Feb 12th, 2005, 6:25 PM	#18
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Sorry - you need to remove it from: (Toggle Plain Text) extension=php_mysqli.dll extension=php_mysqli.dll as well. Note the "i". __________________ Me :: You :: Them

Feb 13th, 2005, 7:54 AM	#20
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Go into System -> Advanced -> Environment Variables (I think). In the System box, scroll down till you find PATH, and edit it so it has your PHP path at the end (paths are separated by semicolons). Or you could just type at the DOS prompt: (Toggle Plain Text) SET PATH=%PATH%;C:\PHP SET PATH=%PATH%;C:\PHP __________________ Me :: You :: Them

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Web Development and Design > PHP

MySQL error 2003