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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.