I need help to mariadb/mysql going on 13.1 milestone 4 new install.

Glenn D. · 08-22-2013, 12:58 AM

Hello,
I need help to log in to mariadb/mysql on 13.1 milestone 4 new install.
Thanks Glenn

What I've done so far:

# rpm -qa | grep -i mariadb | sort
mariadb-5.5.32-1.2.x86_64
mariadb-bench-5.5.32-1.2.x86_64
mariadb-client-5.5.32-1.2.x86_64
mariadb-debug-version-5.5.32-1.2.x86_64
mariadb-errormessages-5.5.32-1.2.x86_64
mariadb-test-5.5.32-1.2.x86_64
mariadb-tools-5.5.32-1.2.x86_64

# mysqld_safe --skip-grant-tables --skip-networking
130822 15:28:22 mysqld_safe Logging to '/var/lib/mysql/orac.site.err'.
130822 15:28:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
#
# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

astrogeek · 08-22-2013, 01:24 AM

Quote:

Originally Posted by Glenn D.

Hello,

# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[EDIT] For clarity... [/EDIT]

In my experience the user, even with --skip-grant-tables, must still be identifiable. In other words, you still could not start the mysql client with mysql -u nobodyhome.

And on my own systems, -u root results in the error message that you see, whereas -u root@localhost does not (I do not fully understand why, but that is how it works).

So...

Code:

mysql -u root - Does not work

mysql - Does work for local users including root

mysql -u root@localhost - Does work