Mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)


Mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)



I'm using xampp. I also downloaded MySQL Database.
Then I have created a database with Mysql Database, with



Then I start Xampp Apache and Mysql.
When I try to connect to localhost:8080/phpmyadmin, I receive this kind of error:



Messaggio di MySQL: Documentazione



Impossibile connettersi: impostazioni non valide.
mysqli_real_connect(): (HY000/1045): Access denied for user
'root'@'localhost' (using password: NO)



phpMyAdmin ha provato a connettersi al server MySQL, e il server ha
rifiutato la connessione. Si dovrebbe controllare il nome dell'host,
l'username e la password nel file di configurazione ed assicurarsi che
corrispondano alle informazioni fornite dall'amministratore del server
MySQL.



So I think that I should modify the file:config.inc.php but the problems are:


config.inc.php



Can you help me to solve this problem? I need to create a simple login form in Java and I need the connection with a database (maybe you know some other solutions to do this.)
Thank you.




1 Answer
1



Please, execute the following privileges command on your MySQL Server:


GRANT ALL ON *.* TO `root`@`localhost` IDENTIFIED BY '123456789';
GRANT ALL ON *.* TO `root`@`127.0.0.1` IDENTIFIED BY '123456789';



Did it solve your problem?



Cheers,





Hi thanks for your answer, can you follow me just another time? I open terminal, and i write: /usr/local/mysql/bin/mysql -uroot -p Then I should paste : GRANT ALL ON . TO root@localhost IDENTIFIED BY '123456789'; GRANT ALL ON . TO root@127.0.0.1 IDENTIFIED BY '123456789';
– Keyz23
Jul 1 at 17:43


root


localhost


root


127.0.0.1





When i insert your code i receive this error: GRANT ALL ON . TO root@127.0.0.1 IDENTIFIED BY '123456789'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '123456789'' at line 1
– Keyz23
Jul 1 at 20:23



root


127.0.0.1






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

How to make file upload 'Required' in Contact Form 7?

How to make file upload 'Required' in Contact Form 7? I have a Contact Form 7 form on my Wordpress website and I have specified that the file upload is mandatory by putting a * , however the users are able to submit the form without file upload. * Relevant Contact Form 7 form is given below: <div class="filelink">[file* AddanImage filetypes:gif|png|jpg|jpeg]</div> How do I write the Contact Form 7 code or add a validation perhaps so that the users are not able to submit the form without uploading an image? Any hints/help/guidance is highly appreciated. Have you check doc - contactform7.com/file-uploading-and-attachment – Mukesh Panchal Jun 30 at 8:38 @MukeshPanchal I have and the code complies with the documentation – Hamza Ahmad Jul 1 at 10:44
Read more

Rothschild family

Image
"House of Rothschild" redirects here. For the film, see The House of Rothschild. For other uses, see Rothschild (disambiguation). Rothschild Jewish noble banking family Coat of arms granted to the Barons Rothschild in 1822 by Emperor Francis I of Austria Ethnicity Jewish Current region Western Europe (mainly United Kingdom, France, and Germany) [1] Etymology Rothschild (German): "red shield" Place of origin Frankfurter Judengasse, Frankfurt, Holy Roman Empire Founded 1760s (1577  ( 1577 ) ) Founder Mayer Amschel Rothschild (1744–1812) (Elchanan Rothschild, b. 1577) Titles List Freiherr von Rothschild (1822) Baronet, of Tring Park (1847) Baron Rothschild (1885) Traditions Judaism, Goût Rothschild Motto Concordia, Integritas, Industria (English: Harmony, Integrity, Industry ) Estate(s) List British properties Château de Ferrières Palais Rothschild Cadet branches List Austrian branch English branch French branch Neapolitan branch A Rothschild house, Wadd
Read more

amazon EC2 - How to make wp-config.php to writable?

Image
amazon EC2 - How to make wp-config.php to writable? I'm using Amazon EC2 with Bitnami wordpress. I recently tried to use plugins, they install and activate well, but there are still errors. Those errors look like permission errors. Also, perhaps, how to make the whole wordpress directory writable? I'm only accessing through SSH. Some of the errors: "A definition of a siteurl or homeurl was detected in your wp-config.php, but the file is not writable. Set your wp-config.php to writable and reload this page." From W3 total Cache: Please add the error messages you get back. – Damien Feb 8 '17 at 12:42 one is: " A definition of a siteurl or homeurl was detected in your wp-config.php, but the file is not writable. Set your wp-config.php to writable and reload this page."
Read more