Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Error 1045 MySQL during setup

Tags:

mysql

Could anyone explain to me error 1045 during MySQL setup. I'm getting this error after reinstalling. I 'm trying to install on windows 7. On the last stage of installation (i.e apply security settings) I'm getting the following message:

The security settings could not be applied. Error Number 1045.
Access denied for user 'root' @ 'loaclhost'(usinf password: NO).

How can I get around this?

like image 527
Falconx Avatar asked Apr 29 '12 18:04

Falconx

People also ask

How do I fix error 1045 in MySQL?

How to fix “Error 1045 (28000) access denied for user 'root'@'localhost' (using password: yes)”? It arises when you perform a fresh installation of MySQL and try to login with a password. The default password of MySQL is blank () (i.e. empty string). So, you can login to the MySQL server using the same password.

How do I fix MySQL access denied error?

You will get this error when the user user_name does not have the right to access your MySQL database. To resolve the error, you must create a user with the following command: mysql> GRANT ALL ON *. * to user_name@localhost IDENTIFIED BY 'password';

How do I completely remove MySQL?

To uninstall MySQL on Windows, make sure that your first stop the running server. Once the server is stopped, you can uninstall MySQL via the Windows "Control Panel". Go to "Programs and Features" and select "MySQL" => "Uninstall".

1 Answers

What worked for me on a 64 bit Windows 7 was

  1. Uninstall
  2. Remove C:\Program Files\MySQL
  3. Remove C:\ProgramData\MySQL (This folder may be hidden)
  4. Reinstall
like image 112
Torben Avatar answered Oct 29 '22 16:10

Torben
Sign in to Comment

Related questions

In MySQL caculating offset for a time zone
Special Characters in MySQL Table Name
Laravel - Invalid parameter number: parameter was not defined
mysql count the sum of all rows
How to set DEFAULT ON UPDATE CURRENT_TIMESTAMP in mysql with sqlalchemy?
Storing application permissions in a database
Better way to select all columns from first table and only one column from second table on inner join
Why does TINYINT(1) function as a boolean but INT(1) does not?
How can I drop all MySQL Databases with a certain prefix?
How can i get server_id in MYSQL?
Add a new column with a value to the select query in Laravel
Finding field with longest length in a column
MYSQL TIMESTAMP comparison
Exclude two conditions in query via Django ORM
Mysql ERROR 1005 (HY000): Can't create table 'tmp' (errno: 13)
joining the same table twice on different columns
MySQL Where date is greater than one month?
MySQL trigger if condition exists
How to Change Order Starting Number in Magento
MySql: if value exists UPDATE else INSERT

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!