#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)

I first changed the root password running mysql at a prompt with mysql -u root -p Update password: UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=”root”; Edited line in the file config.inc.php with the new root password: $cfg[‘Servers’][$i][‘password’] = ‘MyNewPass’ Stop and re-start mysql service (in Windows: mysql_stop.bat/mysql_start.bat) and got phpMyAdmin to work! EDIT 2017: for MySQL≥5.7 … Read more

How to change the URL from “localhost” to something else, on a local system using wampserver?

WINDOWS + WAMP solution Step 1 Go to C:\wamp\bin\apache\Apache2.2.17\conf\ open httpd.conf file and change #Include conf/extra/httpd-vhosts.conf to Include conf/extra/httpd-vhosts.conf i.e. uncomment the line so that it can includes the virtual hosts file. Step 2 Go to C:\wamp\bin\apache\Apache2.2.17\conf\extra and open httpd-vhosts.conf file and add the following code <VirtualHost myWebsite.local> DocumentRoot “C:/wamp/www/myWebsite/” ServerName myWebsite.local ServerAlias myWebsite.local <Directory … Read more

Can’t connect to MongoDB 6.0 Server locally using Nodejs driver

Problem is, the localhost alias resolves to IPv6 address ::1 instead of 127.0.0.1 However, net.ipv6 defaults to false. The best option would be to start the MongoDB with this configuration: net: ipv6: true bindIpAll: true or net: ipv6: true bindIp: localhost Then all variants should work: C:\>mongosh “mongodb://localhost:27017” –quiet –eval “db.getMongo()” mongodb://localhost:27017/?directConnection=true&serverSelectionTimeoutMS=2000&appName=mongosh+1.6.0 C:\>mongosh “mongodb://127.0.0.1:27017” –quiet … Read more

Localhost not working in Chrome, 127.0.0.1 does work

Here are the steps I took to make this work correctly: Edited my hosts file so 127.0.0.1 localhost. was present, and saved the file Cleared my Chrome cache, specifically cookies and cached files Cleared host cache in chrome://net-internals/#dns Restarted chrome Alternatively, this also works: Navigate to chrome://net-internals/#hsts Under “Delete domain”, type localhost and delete Unbeknownst … Read more

How to turn on/off MySQL strict mode in localhost (xampp)?

->STRICT_TRANS_TABLES is responsible for setting MySQL strict mode. ->To check whether strict mode is enabled or not run the below sql: SHOW VARIABLES LIKE ‘sql_mode’; If one of the value is STRICT_TRANS_TABLES, then strict mode is enabled, else not. In my case it gave +————–+——————————————+ |Variable_name |Value | +————–+——————————————+ |sql_mode |STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION| +————–+——————————————+ Hence strict mode … Read more

RMI connection refused on localhost

The target of Naming.rebind() is the RMI Registry. It has to be running. It wasn’t running. So you couldn’t connect to it. So you got a ConnectException. I believe that the code for Implementation does not matter as it simply is the implemented interface that will run the code. This is both meaningless and irrelevant. … Read more

Get err_connection_refused accessing django running on wsl2 from Windows but can curl from Windows terminal

Seems like a forwarding problem. WSL2’s interface is NAT’d, whereas WSL1 was bridged by default. WSL seems to do some “auto-forwarding” of ports, but only on localhost. However, sometimes this auto-forwarding mechanism seems to “break down”. The main culprit seems to be hibernation or Windows Fast Startup (which are both closely-related features). Does the problem … Read more

Sending email from localhost

If you want to send emails from localhost directly, you need to install a Mail Transport Agent (MTA), or if you like, a SMTP service. IIS provides one. You can otherwise find some others on Google. You can also change your php.ini mail settings. This won’t use localhost per say to send emails, but a … Read more

Cannot load Deezer API resources from localhost with the Fetch API

You can make the request through a public CORS proxy; to do that try changing your code to: fetch(‘https://cors-anywhere.herokuapp.com/http://api.deezer.com/search/track/autocomplete?limit=1&q=eminem’) That sends the request through https://cors-anywhere.herokuapp.com, which forwards the request to http://api.deezer.com/search/track/autocomplete?limit=1&q=eminem and then receives the response. The https://cors-anywhere.herokuapp.com backend adds the Access-Control-Allow-Origin header to the response and passes that back to your requesting frontend code. … Read more