Koozali.org: home of the SME Server

mysql phpmyadmin

mike

mysql phpmyadmin
« 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' ;

Dan Brown

Re: mysql phpmyadmin
« Reply #1 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...

mike

Re: mysql phpmyadmin
« Reply #2 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