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';

The solutions for MySQL Error1348

So you can not 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 use 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.

Mysql is a large enterprise database system that is proven to be capable of handling so many database transactions in many big companies' big production data centers.

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.

Popular posts from this blog

How To Connect SSH Using PEM Certificate On Windows

Intellij Error: Spring class file has wrong version 61.0, should be 55.0

Step by Step How To Use cURL Library Using C From VS Code Windows

Spring Kafka - how to use ReplyingKafkaTemplate send and reply synchronously