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
- Code: Select all
mkdir /var/run/mysqld
and then
- Code: Select all
sudo ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock
Unfortunately it didn't work.
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:
select
insert
update
delete
execute
Going to see if via terminal I can force privileges onto that user.