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