Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Wed, 2005-11-16 at 07:26 -0700, Craig White wrote:
> Development version 1.246 - New CentOS install - mysql-
> server-4.1.12-3.RHEL4.1
> 
> this probably has to do with my basic unfamiliarity with mysql
> 
> service mysqld start
> 
> mysqladmin -u root passwd "password"
> 
> no problems...I can login as root with the password I've given it.
> 
> I cannot log into mysql module on Webmin
> 
> I set the administration login and password in the module config but I
> still get access denied with the same login stuff at the login screen.
> 
> It's all localhost stuff and I tried explicity setting the socket
> to /var/lib/mysql/mysql.sock but to no avail.
> 
> Hints?
----
this is frustrating...

# cat /etc/webmin/mysql/config
date_subs=0
perpage=25
stop_cmd=/etc/rc.d/init.d/mysqld stop
mysqldump=/usr/bin/mysqldump
nodbi=0
mysql_libs=
max_dbs=50
start_cmd=/etc/rc.d/init.d/mysqld start
mysql_data=/var/lib/mysql
mysqlimport=/usr/bin/mysqlimport
access=*: *
style=0
mysqlshow=/usr/bin/mysqlshow
mysql=/usr/bin/mysql
add_mode=1
passwd_mode=0
blob_mode=0
mysqladmin=/usr/bin/mysqladmin
sock=/var/lib/mysql/mysql.sock
encoding=
pass=REMOVED
port=3306
host=localhost
login=root

# mysql mysql -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 84 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT host, user, password FROM user;
+--------------------------+---------+------------------+
| host                     | user    | password         |
+--------------------------+---------+------------------+
| localhost                | root    | REMOVED          |
| srv1.despinsprinting.com | root    | REMOVED          |
| localhost                |         |                  |
|                          | root    | REMOVED          |
| localhost                | sqlgrey | REMOVED          |
| *                        | root    | REMOVED          |
| ALL                      | root    | REMOVED          |
+--------------------------+---------+------------------+
7 rows in set (0.00 sec)

mysql>

I cannot connect with webmin

Craig



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.