How do I change the default MySQL user on OpenSuSE 13.1

Question

How do I get the "mysql" command to open a connection to MySQL with the root user? I don't want to type mysql --user root, I want it to start immediately.

I have two machines: Mageia 3 and OpenSuSE 13.1. The Mageia machine does this exactly when I open a terminal as the normal user: it simply starts a mysql session and when I type SELECT USER(); it says "root@localhost".

The OpenSuSE machine tries to use the current bash user to connect to mysql instead of using root. How do I configure this behavior?

score 1 · Answer 1 · answered Apr 03 '15 at 21:52

1

Specify a user option in the [client] section of ~/.my.cnf

...but generally its considered bad practice to use the admin account for normal use of a system.

answered Apr 03 '15 at 21:52

symcbean

47,736
6
59
94

score 0 · Accepted Answer · answered Apr 04 '15 at 06:46

0

Although symcbean's solution works, I found it easier to create a user with the same name as the Linux account that is calling the command. Give this user enough privileges and voilà. This way avoids the problem mentioned by symcbean.

answered Apr 04 '15 at 06:46

A R

500
2
7
20

How do I change the default MySQL user on OpenSuSE 13.1

2 Answers2