Answers for "how to change user name in mysql"

SQL
0

change name of user mysql

RENAME USER old_user1 
TO new_user;
Posted by: Guest on May-01-2020
-1

change user mysql

[madegow@fedora20 ~]$ mysql -u root -p
Enter password: 
...
MariaDB [(none)]> select user()
-> ;
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> system mysql -u madegow -p
Enter password: 
...
MariaDB [(none)]> select user();
+-------------------+
| user()            |
+-------------------+
| madegow@localhost|
Posted by: Guest on January-23-2021

Code answers related to "how to change user name in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language