mrkfox Posted November 30, 2009 Share Posted November 30, 2009 Hi, i have a website which at the moment has user sign up. This part of the website works fine but i would like to create a phpMyAdmin login for that user and their own database upon their sign up. I have tried to edit the 'user' table in the 'mysql' database with no luck. I can successfully enter the user name and any privileges i wish but when it comes to the password I'm stuck. I can easily enter any password i want but when it comes to logging in with phpMyAdmin the password is encrypted and compared to the password stored in the user table. As my password is not encrypted upon entry i cannot log in. It would solve the problem if i could encrypt the password in the same way as phpMyAdmin when my user is signing up. As i think phpMyAdmin uses it's own encryption technique i don;t think i can do this. Has anyone got any ideas? Thanks Link to comment https://forums.phpfreaks.com/topic/183435-creating-a-new-user-for-phpmyadmin/ Share on other sites More sharing options...
JonnoTheDev Posted November 30, 2009 Share Posted November 30, 2009 Just grant access to the new database using the same username & password as the website. http://dev.mysql.com/doc/refman/5.1/en/grant.html Link to comment https://forums.phpfreaks.com/topic/183435-creating-a-new-user-for-phpmyadmin/#findComment-968246 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.