Re: [webmin-l] mysql module

[Jamie C. <jca...@we...>]

On 17/Nov/2005 16:49 Craig White wrote ..
> On Wed, 2005-11-16 at 09:53 -0700, Craig White wrote:
> > 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 stting 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
> ----
> I was hoping to get Jamie or someone to pipe in on this.
> 
> I 'downgraded' to 1.240 and still had the same problem so I went back to
> 1.246 for the benefit of the stuff in LDAP Users and Groups.
> 
> I did manage to get it to work...as long as there is no password for
> root...I'm functional. Perhaps I will try to back it all up, use webmin
> to insert the password for root and then see if webmin can access it but
> I can't think of a reason why I can't set the password with mysqldadmin
> and then login via webmin...I used to always do it that way (mysql-3.x)

Hi Craig,
One common cause of MySQL login problems is the anonymous users. Try deleting
them in Webmin, assuming you can connect without a root password. Then try
turning the root password back on, and seeing if Webmin can login..

 - Jamie