I managed to install XAMPP successfully on my netbook and can access it via the browser and navigate to phpMyAdmin. Also got them up and selectable within terminal. I'm trying to get access via a local GUI client though and have had trouble connecting to the database server all day. I'm trying to use VALENTINA STUDIO which came highly recommended on many forums.

I input the TCP/IP settings OR try the myqld.sock method and both are knocking me out with an error HY000: "Can't connect to MySQL server on '127.0.0.1' (107)"

This is a brand new install of XAMPP.

I setup the security settings in the browser for XAMPP and have saved them each in LASTPASS so I know the passwords and users are correct. I've tried the XAMPP user and pword, the PMA user and pword, and ROOT user and pword.

I've also located the mysqld.sock at /opt/lampp/var/mysql/mysqld.sock It's an empty file though is this correct? Following a suggestion on the Ubuntu forums from 2009 I attempted

In MySQL I have TWO databases - one called mysql and another called phpmyadmin. The latter seems mostly empty and mysql seems to have all the user data and host settings. Try to get the info for the 'host' table and the privileges direct me to the 'db' table instead as it has a 'host' column. There are three entries there. Two tests using % but with nothing in the user field, and the 'pma' user for the phpmyadmin database.

From what I can understand I need to get a wildcard '%' into the host for the 'pma' user. I can't get it to alter though. I'm trying via phpMyAdmin. I even tried creating a new user with the same privileges as the current 'pma' user and it won't save it.

The current previlieges for 'pma' user (which is the root user fro phpMyAdmin) are on for:selectinsertupdatedeleteexecute

Going to see if via terminal I can force privileges onto that user.

Last edited by bunnybooboo on 17. December 2013 11:01, edited 2 times in total.

this allowed me to FINALLY set the wildcard '%' for the 'pma' user in phpMyAdmin. Well I'll be if I still can NOT connect via Valentina. I even restarted XAMPP so it flushed.

Any advice anyone? I'll clearly need to create a new password [EDIT: I've done this now] for the root user whilst I'm on a roll and maybe there is another setting somewhere stopping 'remote' access even though it's on the same lame old reconditioned netbook haha.

What I also now can't fathom is why as root I have access to only two areas in the left of phpMyAdmin: information_schema and test. I can't even select the tables without an error popping up. Under 'databases' tab under create databases it now says 'no privileges'.

Logging in as 'root' is currently done without a password. Right I'm going through all the XAMPP security settings again as I think I'd duplicated the XAMPP browser interface password with root user. Whilst correcting this I notice the settings say

Checking through everything I'd done I found the mysqld directory I'd created back in my op and this had vanished. Woah. Anyway done the procedure again and restored terminal access to mySQL. So if anyone has any suggestions of assistance I will be able to run them through terminal.

EDIT: it turns out this is because it had it in caps. Running the SQL query now runs with out an error BUT seems to not effect the root user despite removing the password manually in phpmyadmin. I also have just tried via terminal and it SEEMS to work but responds with no error but a new line with '->' symbol.

so typical of trying to find the answer for open source software I have gone down so many rabbit trails and not sure if I'm any closer.

I'm quite new to mysql and actually trying to follow a tutorial on XAMPP so am keeping it specifically identical to the tutorial in the hope I might be able to reduce complexities. Mahaha.

To add another complexity when I use root without the password and skip-grant-tables I actually only have TWO databases. pma user when logged in with skip-grant-tables gets THREE databasesroot user WITH skip-grant-tables gets EIGHTpma user WITH skip-grant-tables gets EIGHT

I know I seem to be rather talking to myself here after so many posts to myself but it seems to me and my quite newbie brain that 'pma' actually IS recognised as the root user. I can't work that out though as 'pma' user clearly has far less privileges granted to it when looking of the 'user' table in mysql.

Within this table I have just deleted all the passwords and when trying to log back in via phpmyadmin neither 'root' nor 'pma' users can get in. Sweet. But when I try to reset the password via /opt/lampp/xampp security it still says