SQL databse access for registration script?

January 17, 2014 1.7k views
andrewmf2011
By:
andrewmf2011
Hey, I'm trying to run SQL on my server as well as apache to test out my php registration/login script, I have it set up, and can access it, but it won't write to the database, i suspect this is because it when i go to phpmyadmin I have to login to a javascript popup login box and then login to the actual phpmyadmin page, how can I disable the javascript login box? (in the popup login I have to use the account I setup, but on the actual phpmyadmin login I have to use the root account)
Log In to Comment
5 Answers
kamaln7 MOD January 18, 2014
Your php script does not use phpMyAdmin to connect to MySQL so the javascript login box is unrelated. Make sure that your database credentials are correct and check for MySQL errors.
Reply
andrewmf2011 January 19, 2014
Thanks, I think I found the problem but now I'm stuck again :(

I need to allow remote connections to the sql server right? I tried to set it up but it didnt work, do you know of a good simple guide for that?
Reply
kamaln7 MOD January 20, 2014
Are you trying to connect from your computer to MySQL running on your droplet? If so, check out https://library.linode.com/databases/mysql/mysql-ssh-tunnel.
Reply
andrewmf2011 January 26, 2014
I'm trying to connect and write data through a web browser on any computer, so that people can register with one page and it saves it to the database and then they can login with another page that checks if the usernsme/password are on the database and if they are displays a welcome message

After doing mysql and webdesign at college for a couple of months I thought it would be nice to try, I'm not trying to make it for a specific use, just for fun really
Reply
kamaln7 MOD January 30, 2014
That sounds fine, you don't need phpMyAdmin to be able to do that. Google "php login/register tutorial" and you'll find lots of resources on that :]
Reply
Have another answer? Share your knowledge.