Re: [webmin-l] mysql module

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

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

Craig


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