marche

I used to be able to do that on 7.x, how do I do that on 8.x? I can enable the security, but what directory should I allow from all, and what file should I edit to allow phpmyadmin remote access?

Hi, I am developing a system where posts will 'sync' with another master db (in this case, the remote db). I didnt try yet built in mysql syncing (Because I will be merging several transaction tables into one master transaction table). I wanted to use PHP to update transaction tables found on the local mysql tables to a remote db. This is why I am trying to connect to the remote db. Yes the host is hostgator and it is running on a LINUX box. Googling that first line of error gave me this link: C.5.2.4. Client does not support authentication protocol Which seems to suggest that I need to update my client (which my host also said) They said that I should run php -v mysql -V httpd -l so they can help me. However I am at a loss on running console in US. I used to make my own apache+php+mysql using the default installers (and running console on that), but this is the first time I am using a WAMP (I needed the portability of US).

I got this error when trying to connect to a remote mysql installation. mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file My host said it is because my libmysqlclient is outdated (still using pre-4.1 authentication). However, I need to know how I can update it? Any ideas? I am using the 5.6.16 on my windows 7 machine.