Hi folks,
This is my 1st message here, I am currently learning SME. I have a small experience with Linux environments but I am not familiar with SME at all.
I have read the docs, FAQ and Howtos but I can't find what I am looking for.
I need to allow access to Mysql for a specific user on my network. He needs to extract some data periodically.
I have phpmyadmin running on my SME server. I have managed to configure the user account from the MySQL side. Meaning that the SQL user I've created in mysql is valid, the user only has access to the GRANT command so he can read data etc... it works via command line with the mysql command prompt, so I know that Mysql config is ok.
I have created a user account for my colleague in the sme server web configuration page, with a password.
Thing is, when he browses to
http://ourserver/phpmyadmin then what I do believe is an apache authentication is asking for credentials, but then again if I try to authenticate with his credentials which I have created under SME, it just doesn't work. I can only access to the apache authentication that you get just before you access to the phpmyadmin page with the admin credentials.
I can authenticate with the users credentials in phpmyadmin with no probs.I can authenticate in mysql too as I've said, but this little apache authentication window is driving me nuts and I just don't know where to look now.
I've read a couple of posts about an installation of phpmyadmin for mulitusers access, but I just can't reinstall the phpmyadmin package. I am sure there's a way to tell apache to let the user access to
http://oursme/phpmyadmin but I am clueless.
Thanks for your help
1 Replies
1629 Views