ERROR 1348 Column Password Is Not Updatable When Updating MySQL Root Password

MySQL and MariaDB password

As already mentioned in the title of this blog, this error message sometimes occurred when we are trying to update our root password database, either MySQL or MariaDB, The error says:

ERROR 1348 (HY000): Column 'Password' is not updatable

This is because if we use this SQL command to update our database root password, and it turn out to be Restricted by MySQL to use update on mysql database.

UPDATE mysql.user SET Password=PASSWORD('1234') WHERE User='root';

So you can't update a user password using Update commands, to update the password, use ALTER commands instead. like the following.

ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';

And then you need to do the flush privileges to commit previous queries (that alter command above) into the system, simply do like this.

flush privileges;

So now you have your root with password 1234. Although it is recommended to use much more stronger unpredictable password. Never user 1234 as password of any of your login credentials, unless it is just for testing.

So I've been using MySQL since the beginning of my software development carrier. Still, i got trouble memorizing some SQL commands, to as simple as updating mysql user password, i can do that without looking to this blog for reference. So this blog is become my public note book.

Not only changing root password, you can also change any other MySQL user in your database using Alter command, don't using Update. Update is more to updating our own database, not MySQL system database like database named mysql, it is in fact an auto generated MySQL default database. It is used for storing list of eligible users, MySQL system configuration, languages, etc.

MySQL or MariaDB is one of My favorite relational database system (RDMS) for either developing or even i use it for my production services. It is easier to install MySQL and to manage it than any other competitor database system out there. It make my application development so much fast, and also stable in our production application.

I love MySQL, it is fast, and using SQL dialect that lot of peoples use, so in case i got trouble with some SQL commands to do something, just by searching online on Google I can find the solution right away. You can do from simple SQL queries, to advanced complex queries, MySQL can handle that, fast and reliable.

I think MySQL probably the perfect free database system in the world, even it is free but it is been proven to be the right choice for many start up or even big companies out there. Although there's several cons, MySQL still evolved and improve their system to be better and better.


Comments

Popular posts from this blog

Flixify Video Streaming Platform, Watch Movies and TV Show Online

ASUS Battery Health Charging Software To Make Your Battery Life Longer

How To Uninstall Angular CLI, The Angular Framework

JavaFX Combo Box with Search Autocomplete

Is Nox Player a Malware? Nox Android Emulator