mysql to mariadb upgrade

kuba_66 · 2013-04-02 11:43:23

Perhaps it's a newbie problem ...
I did as recommended in Arch news:

 # systemctl stop mysqld
# pacman -S mariadb libmariadbclient mariadb-clients
# systemctl start mysqld
# mysql_upgrade -p

After the last command I received a prompt to enter password. I had never entered any mysql passwords before (or I don't remember), so I thought it should be a new password. On entering a new password I received an error message, so I did:

# mysql_upgrade

and no errors were reported.
Is that the right way of doing things?

Barthalion · 2013-04-02 11:48:06

If you are sure that you didn't set any password before, everything went fine.

mrunion · 2013-04-03 01:03:11

If you can't remember the password, there is an admin tool that will allow you to recover it. I can't remember the exacts steps, but Google should help out!

eerok · 2013-04-05 01:52:53

I wouldn't set a password for mysql that wasn't my root or main user password, but I still get this no matter what I try

# mysql_upgrade -p
Enter password: 
Phase 1/3: Fixing table and database names
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
FATAL ERROR: Upgrade failed

I tried resetting the password using these instructions and it didn't solve the problem.

sultanoswing · 2013-04-07 01:08:20

eerok wrote:

I wouldn't set a password for mysql that wasn't my root or main user password, but I still get this no matter what I try
# mysql_upgrade -p
Enter password: 
Phase 1/3: Fixing table and database names
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
FATAL ERROR: Upgrade failed
I tried resetting the password using these instructions and it didn't solve the problem.

Did you try 'sudo' before 'mysql_upgrade' ?

eerok · 2013-04-07 01:37:30

sultanoswing wrote:

Did you try 'sudo' before 'mysql_upgrade' ?

Well, I executed it as root.

Anyway, it's not clear what didn't work, since there have been no adverse consequences. Maybe I'm okay.

cfr · 2013-04-07 02:27:20

Is there any disadvantage to having (or not having) a password set for mysql? Since upgrading seems to entail setting one...

I guess I'm not sure whether I should upgrade or not since I don't really know anything about mysql. (kde seems to be using it - I don't use it directly.)

cfr · 2013-04-08 03:37:02

I read the wiki instructions for upgrading. These say to stop mysql before uninstalling it and replacing with mariadb. That makes sense. However, systemctl doesn't seem to know about mysqld on my system.

$ ps ax | grep mysql
 2312 ?        Sl     0:35 /usr/bin/mysqld --defaults-file=/home/username/.local/share/akonadi/mysql.conf --datadir=/home/username/.local/share/akonadi/db_data/ --socket=/home/username/.local/share/akonadi/socket-MyComputer/mysql.socket

So I guess that KDE starts it directly and it is running per user.

What is the correct way to stop mysqld in this case?

Also, I noticed that the systemd service file starts mysql with /usr/bin/mysqld. The very little I remember about mysql involved starting it only with mysql_safe (or safe_mysql or something similar). I was just curious why that was.

progandy · 2013-04-08 04:11:14

cfr wrote:

So I guess that KDE starts it directly and it is running per user.
What is the correct way to stop mysqld in this case?

Logout and use a root tty for the upgrade I suppose. Then login again.

Also, I noticed that the systemd service file starts mysql with /usr/bin/mysqld. The very little I remember about mysql involved starting it only with mysql_safe (or safe_mysql or something similar). I was just curious why that was.

mysql_safe implements restart on failure/crash which is unnecessary with systemd since it already has those capabilities.

papa6 · 2013-05-11 17:57:41

Hi kuba_66,
There are 2 different passwords you need to type : first the one being root on your computer, and the last one is the mysql root password.

One way is to use sudo :

$ sudo systemctl stop mysqld
$ sudo pacman -S mariadb libmariadbclient mariadb-clients
$ sudo systemctl start mysqld
$ sudo mysql_upgrade -p

At the last line, the password you should provide is the one for your DB account.

Arch Linux

#1 2013-04-02 11:43:23

mysql to mariadb upgrade

#2 2013-04-02 11:48:06

Re: mysql to mariadb upgrade

#3 2013-04-03 01:03:11

Re: mysql to mariadb upgrade

#4 2013-04-05 01:52:53

Re: mysql to mariadb upgrade

#5 2013-04-07 01:08:20

Re: mysql to mariadb upgrade

#6 2013-04-07 01:37:30

Re: mysql to mariadb upgrade

#7 2013-04-07 02:27:20

Re: mysql to mariadb upgrade

#8 2013-04-08 03:37:02

Re: mysql to mariadb upgrade

#9 2013-04-08 04:11:14

Re: mysql to mariadb upgrade

#10 2013-05-11 17:57:41

Re: mysql to mariadb upgrade

Board footer