have installed phpmyadmin on opensuse version 13.1
want to have acces to login without passwd
You either have to change the root password in mysql, or allow an empty root password in line 100 in /etc/phpMyAdmin/config.inc.php:
i set the config accordingly
line 92
// MySQL user
$cfg'Servers']$i]'user'] = 'root';
// MySQL password (only needed with 'config' auth_type)
$cfg'Servers']$i]'password'] = '';
// Allow access without password
$cfg'Servers']$i]'AllowNoPassword'] = true;
// whether to allow root login
$cfg'Servers']$i]'AllowRoot'] = true;
// Session to use for 'signon' authentication method
$cfg'Servers']$i]'SignonSession'] = '';
i have the following options - note; this results are not an output of my work - i only have had a look a the methods and ways i can go…
The normal way of setting a password for mysql does not work on opensuse 11.0
localhost:/etc # mysqladmin -u root password xxx
mysqladmin: connect to server at 'localhost' failed
see the following .,
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Suse is using some strange /etc/my.cnf file which has the following section
# The following options will be passed to all MySQL clients
[client] #password =xxx
port = 3306
socket = /var/lib/mysql/mysql.sock
Using this password entry changes the “password: YES” or “password: NO” answer.
Now I am totally lost on configuring mysql and doing such simple tasks as setting of root password.
Any help appreaciated, also any introduction into the how and why suse does it the way it works (which is different to usually).
again - not my results and findings - but i thought that this above mentioned thread is useful.
accordin this thread i did use the following code in terminal
$ mysql -u martin -h localhost -p
mysql -u martin -h localhost -p
Enter password:
ERROR 1045 (28000): Access denied for user 'martin'@'localhost' (using password: YES)
well - you see that i need to do something. there __ must ___ be a root passd for the mysql-db
Well, I hope you do realize that this thread is from 2008?
Not all details there might still be appropriate.
accordin this thread i did use the following code in terminal
$ mysql -u martin -h localhost -p
mysql -u martin -h localhost -p
Enter password:
ERROR 1045 (28000): Access denied for user ‘martin’@‘localhost’ (using password: YES)
Hm?
Do you actually have a mysql user named “martin”?
Try root as I said. If the password is empty, you can omit that “-p”, that option tells mysql to ask for a password.
MySQL DOES NOT automatically import the system’s users. On a default openSUSE installation, there’s only “root” with an empty password.
well - you see that i need to do something. there __ must ___ be a root passd for the mysql-db
how to change / how to procceed now?
Well, as I said, you probably have setup a password for root, but the things that you posted here don’t tell anything.
Please run this, as I said before, and post the output:
mysql -u root
And again, if you setup a password for root (or any other user as which you try to log on), you have to enter the password in phpMyAdmin. There’s no way around that (that’s the whole point of setting up a password, isn’t it?).
mysql -u root -h localhost -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 5.5.33-MariaDB openSUSE package
Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB (none)]>
welll now i know.
the access to the db is with
user root
passwd: the passwd for the root user on the machine.
guess that we subsequently can move aehead with our question of access for the phpmyadmin - can ´t we?
