mysql issue

[reggler]

Hi There,

I'm trying to get XAMPP http://www.apachefriends.org/en/xampp.html installed and up and running to get a local development version of Joomla http://www.joomla.org/ going but i'm facing issues with MySql, Apache is no problem but XAMPP wouldn't start mysql because there's already an instance running on my system:

reg@reg-desktop:~$ ps ax | grep mysqld
 1304 ?    Ssl  0:00 /usr/sbin/mysqld
 2642 ?    Sl   0:00 /usr/sbin/mysqld --defaults-file=/home/reg/.local/share/akonadi//mysql.conf --datadir=/home/reg/.local/share/akonadi/db_data/ --socket=/home/reg/.local/share/akonadi/socket-reg-desktop/mysql.socket
 3805 pts/3  S+   0:00 grep mysqld

Now, how can I configure XAMPP to use this certain instance and also how do I find out the login information (to configure phpmyadmin and joomla)?

Any help is appreciated!
Thank you!
Ron

[reggler]

Re: mysql issue

ok, i figured out that i can get some info with the mysql shell interface.
I got the user which is "reg@localhost" (my local user name, got it from mysql shell with status) and i didn't get asked for a password thus i assume, no password is configured. I entered the info in /opt/lampp/phpmyadmin/config.inc.php ($cfg['Servers'][$i]['controluser'] = 'reg';)but when opening phpmyadmin in the browser i get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) and Connection for controluser as defined in your configuration failed. -

Any clues what I might be missing?

Thank you!
Ron

[MoonRise]

Re: mysql issue

Oddly enough I just recently installed XAMPP. I used 11.04 64bit desktop Kubuntu as the base. All worked well except trying to change the MySQL root password. Yes the root password for MySQL that XAMPP ships out with is blank. Their method to set a password doesn't seem to work. Get a lot of Wrong Statement errors and to review the manual. Anyway, I think from what I know the config file for MySQL may be set to the wrong SOCK file or maybe even the SOCK file is wrong or corupt. Just guessing here. I'm more a MS SQL person and just recently started reviewing over MySQL.

[reggler]

Re: mysql issue

Well, the password isn't the problem, xampp can't start mysql cause there's another instance of it running already so i wanna configure xampp to use that one...thinking it might be coming from akonadi...?

[MoonRise]

Re: mysql issue

Possibly, but I wouldn't know further what to check. Don't know if you can have to instances running but on different ports. Worth a web search. Then all you have to do is change the XAMPP config file for that instance of MySQL for a different port, IF it can do that.