Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: mike on September 25, 2001, 04:08:25 AM

Title: mysql phpmyadmin
Post by: mike on September 25, 2001, 04:08:25 AM

I want use mysql with phpmyadmin with sme v5
I have installed phpmyadmin in ibays creat  mysql password :
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

I can creat mysql base with phpmyadmin but creat valide user and allow privileges to user are possible
 only in e-smith console :
mysql -u root -p
mysql>GRANT ALL PRIVILEGES ON mybase.* TO myuser@localhost IDENTIFIED BY 'mypass' ;

Title: Re: mysql phpmyadmin
Post by: Dan Brown on September 25, 2001, 07:13:42 AM

Well, since you can execute arbitrary SQL in phpMyAdmin, there's no reason I can see why you couldn't do the "grant all" there...

Title: Re: mysql phpmyadmin
Post by: mike on September 25, 2001, 10:49:13 AM

Thanks for your reply.

but is not a dream and when webmail is enabled
i have a mysql error too(when I try to access)  :
Warning: Access denied for user: 'hordemgr@localhost' (Using password: YES) in /home/httpd/horde-phplib/db_mysql.inc on line 73