On an old CentOS server, I have a MySQL and on a new CentOS server, I installed MariaDB. On old server my DB are:
Code: Select all
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| livezilla |
| mysql |
| performance_schema |
| store |
| temp |
| test |
+--------------------+
mysql> select user from mysql.user;
+-----------+
| user |
+-----------+
| jason |
| root |
| jason |
| jason |
| root |
| livezilla |
| magento |
| root |
+-----------+
On old CentOS, the username is "jason" and on new CentOS, the username is "john", Can it cause any problem? In "mysql.user", the "jason" username created automatically or by system administrator?
Thank you.