By Laischon
Hi! I have a problem with mySQL. Checking the error log, i saw a list of [Note] Access denied for user ‘root’@‘localhost’ (using password: YES) errors for every day.
Can someone tell me why that’s happened? How can i know who or what is trying to acceed with root?
(I’m so sorry for my bad english :P )
Thx, Nicholas
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
My english is very bad, but in you console you can create a new user with all privileges. May be your password is wrong:
- mysql -u root -p -h localhost *CREATE USER ‘myNewUser’@‘localhost’ IDENTIFIED BY ‘myNewPassword’; *GRANT ALL PRIVILEGES ON . TO ‘myNewUser’@‘%’; *FLUSH PRIVILEGES;
Now you can enter whit the user myNewUser.
Hello, I installed mysql and joomla while installation i crated a db joomla now when i am going to make configuration from localhost/joomla showing error : Error Could not connect to the database. Connector returned number: Could not connect to MySQL server.
from my local when i am going to connect to mysql then showing error, ERROR 1045 (28000): Access denied for user ‘pytondev’@‘localhost’ (using password: NO)
PLEASE HELP ME OUT FOR THIS.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.