dbTalk Databases Forums  

Problem connecting do lampp mysql server

mailing.database.mysql-plusplus mailing.database.mysql-plusplus


Discuss Problem connecting do lampp mysql server in the mailing.database.mysql-plusplus forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jonas Jurczok
 
Posts: n/a

Default Problem connecting do lampp mysql server - 01-16-2006 , 05:58 AM






Hi there again.

I solved the Problem described in the Thread above... but therefore I
dont know how to answer to a Thread here I couldnt write it.. *beginners
fault *

The trick was to compile the mysql++ rpms with the tar.gz package.
now I got the examples and the next problem..

I tried to create the sample Db with ./resetdb localhost root <psswd>
but I allways get the following error:

[root@localhost examples]# ./resetdb localhost root <psswd>
Connecting to database server...
Connection failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

The Server Im running is the newest lampp Apache/MySQL Server from
www.apachefriends.org and it works wounderfull (tested it!).

Has anyone a hint for me why this doesnt work?
I've read all Readme files I found but nothing helped..

thx 4 Help

J. Jurczok

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw


Reply With Quote
  #2  
Old   
Jonas Jurczok
 
Posts: n/a

Default RE: Problem connecting do lampp mysql server - 01-16-2006 , 07:26 AM






hmm
i noticed, that the error message says that it has problems with
/var/lib/mysql/mysql.sock
i checked and: /var/lib/mysql/ is empty...

why?
how to change?

thx 4 help

Jonas Jurczok

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw


Reply With Quote
  #3  
Old   
Warren Young
 
Posts: n/a

Default Re: Problem connecting do lampp mysql server - 01-16-2006 , 08:37 AM



Jonas Jurczok wrote:
Quote:
Connection failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
The MySQL server is not running. As root, say:

service mysql start

To ensure that it starts when the system boots, use the ntsysv tool.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw



Reply With Quote
  #4  
Old   
Jonas Jurczok
 
Posts: n/a

Default Re: Problem connecting do lampp mysql server - 01-16-2006 , 09:11 AM



so it is not possible to use the lampp mysql server with the mysql++ api?

because the lampp mysql server _was_ running..

as I tried to start the mysql server you told me i got an error..
so i stopped the lampp serverpackage and tried again..

mysql started but I was unable to set password for root@localhost

error msg:

[root@localhost ~]# /usr/bin/mysqladmin -h localhost -u root password
<newpass>
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

but thats not so important.. examples work..

but the problem i have now is:
can I use phpmyadmin with this server or not?
because the project I want to code is based on the MySQL server included
in the lampp package.

hope so and thx 4 help

J. Jurczok

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw


Reply With Quote
  #5  
Old   
Warren Young
 
Posts: n/a

Default Re: Problem connecting do lampp mysql server - 01-16-2006 , 02:54 PM



Jonas Jurczok wrote:
Quote:
so it is not possible to use the lampp mysql server with the mysql++ api?
I can't answer that question because I don't know how a "lampp mysql
server" differs from the MySQL server you can download from mysql.com.
MySQL++ obviously works fine with the standard MySQL server.

Quote:
[root@localhost ~]# /usr/bin/mysqladmin -h localhost -u root password
newpass
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

but thats not so important.. examples work..
I'm confused...you can't use mysqladmin, but the examples work.... How
does that happen?

Quote:
can I use phpmyadmin with this server or not?
That's not on topic here.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw



Reply With Quote
  #6  
Old   
Jonas Jurczok
 
Posts: n/a

Default Re: Problem connecting do lampp mysql server - 01-16-2006 , 03:49 PM



yep.. the topic was not neccessary.. but i learned that just atm..

the lampp mysql server is packed up with phpmyadmin (like webmin) and an apache webserver..
differs just in the gui..

the mysqladmin command without -h ... worked.. and after reinstalling webmin i finally got control over the server

so examples work and everything is fine..

except that i get "undefined reference" errors to all functions delivered with mysql if i write the code on my own (almost copy&paste)..

I dont know why but I will work it out tomorrow..

the funny thing is: i got a spelling mistake (forgot a _ ).
result: 1 Error

i corrected the error
result: almost 100 errors -.-

so maybe the *.cpp file is corrupted or just another mistake I didnt find up do now..

lets se

J. Jurczok
__________________________________________________ ____________
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.