How to connect to a database after installatio

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

How to connect to a database after installatio

Postby apasho » 16. January 2007 16:14

I have install xampp. I can get both apache and mysql to start up as services, but I can not connect mysql to any of the databases that came with the download. When I view the localhost in a browser and check status it says mysql is deactivated. When I first installed it the mysqlAdmin told me there was no odbc driver so I installed the odbc drive it was missing. I have replace the ntwdblib.dll with a later version... I have looked at the readme file: I do not understand how to perform this:
"you can connect the MySQL-Server with: mysql_connect("localhost","root","");"

What am I missing?
apasho
 
Posts: 4
Joined: 16. January 2007 15:49
Location: Mar Del Plata, Argentina

Postby Wiedmann » 16. January 2007 17:07

I can get both apache and mysql to start up as services,

You can really see MySQL in the task manager?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby apasho » 16. January 2007 19:39

yes, I can see mysqld.exe in the taskmanager
apasho
 
Posts: 4
Joined: 16. January 2007 15:49
Location: Mar Del Plata, Argentina

Postby Wiedmann » 16. January 2007 20:01

I can see mysqld.exe in the taskmanager

IMHO with XAMPP this should be "mysqld-nt.exe" (installation and start as service)

Can you check with "xampp-portcheck.exe" if the correct MySQL server is started?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby apasho » 16. January 2007 21:20

Please wait a moment...


RESULT
------

Service Port Status
=============================================================
Apache (HTTP) 80 C:\xampp\apache\bin\apache.exe
Apache (WebDAV) 81 free
Apache (HTTPS) 443 C:\xampp\apache\bin\apache.exe

MySQL 3306 C:\xampp\mysql\bin\mysqld.exe

FileZilla (FTP) 21 free
FileZilla (Admin) 14147 free

Mercury (SMTP) 25 free
Mercury (POP3) 110 free
Mercury (IMAP) 143 free

What should I do to get the correct mysql running?
apasho
 
Posts: 4
Joined: 16. January 2007 15:49
Location: Mar Del Plata, Argentina

Postby apasho » 16. January 2007 23:08

Run mysqlshow results:
Access denied for user 'ODBC'@'localhost' (using password: NO)
apasho
 
Posts: 4
Joined: 16. January 2007 15:49
Location: Mar Del Plata, Argentina

Postby Wiedmann » 17. January 2007 00:30

Apache (HTTPS) 443 C:\xampp\apache\bin\apache.exe

OK, MySQL from XAMPP is running.

When I view the localhost in a browser and check status it says mysql is deactivated.

- This is a new (no upgrade) installatiion of XAMP?
- What is the error message in the cd database demo?

- How have you installed XAMPP (exact steps)?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 3 guests