And I’m sure that I’m typing the correct password, because I try one and one again
And this happens since I updated suse from 3.1 to 3.2. (I really don’t know I that has something to do with this but just in case).
Maybe it’s a bug. I’ll look for it in bugzilla and report it in case is not there.
You have “#” in the shell prompt, so it seems that you are already root? No need to ‘sudo’ then! But even root can ‘sudo’ of course. In the ‘sudo’ dialog provide user’s (in case root’s) password (of the OS root user - not the MySQL root user). Once your sudo authentication has been approved, the MySQL client will ask you for MySQL authentication detals.
But as you upgraded from a previous version there may also be some issue with upgrading MySQL. OpenSuSE 12.3 ships with MariaDB 10.0.14. I am not sure what 12.2 and 12.1 did (12.2 had a MariaDB 5.x version, I think. 12.1 may have had a server from Oracle and not from MariaDB). You may simply uninstall the old server (your data will not be deleted - but still I’d recommend that you make a copy of the /datadir) and install again from either SuSE’ s repo or MariaDB’s (https://downloads.mariadb.org/mariadb/repositories/#mirror=klaus&distro_release=opensuse13-amd64&distro=openSUSE&version=10.0). Don’t follow their (ignorant as regards SuSE) recommendation on how to register the repo - just use YaST or zypper as you normally would. If you use a MySQL/MariaDB /datadir from an older version don’t miss to run ‘mysql_upgrade’ (http://dev.mysql.com/doc/refman/5.6/en/mysql-upgrade.html) immediately after the upgrade.
I have communicated (quite a lot) on the MariaDB mailing list about their repo for SuSE (I am working for a company who is a MariaDB business partner - they distribute our programs and we provide support for those programs to their customers) . There are some few issues with the MariaDB repo - most important
“rpm -qa” command don’t list packages installed from the MariaDB repo.
conflicts with KDE and some KDE applications are not resolved automatically (these applications will - as they have an option to save their data in MySQL (embedded or not) - have a dependency on a two shared libraries that needs to be replaced). One such application is Amarok. These dependencies is not deteted by MariaDB RPMs . You can resolve the conflict manually from YaST GUI.
Apart from this, you will not at all need to be (OS)-root user to invoke the ‘mysql’ client and connect to the MySQL server, as long as you provide valid MySQL authentication details (for any existing MySQL user) . The file /usr/bin/mysql (the client program) is readable for all (and if it is not, it is a bug somewhere!).
Aren’t you just confusing the concept of ‘root’ in Linux and in MySQL? They are completely unrelated.