access to phpmyadmin without passwd - not possible

[Guest sayhello]

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

Code:

// 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'] = '';

cannot access with the following:

 

use root

pass empty

 

 

what to do

update:

 

 

 

 

according this thread

 

https://forums.opensuse.org/showthre...mysql-password

 

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...

 

Quote:

The normal way of setting a password for mysql does not work on opensuse 11.0

 

Code:

localhost:/etc # mysqladmin -u root password xxx

mysqladmin: connect to server at 'localhost' failed

see the following .,,,,

Code:

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.

 

 

see another interesting thead

 

http://www.cyberciti.biz/faq/how-to-...-line-and-php/

 

 

accordin this thread i did use the following code in terminal

 

Code:

 

$ 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

 

how to change / how to procceed now?

 

look forward to hear from you

 

Continue reading...