SQL databse access for registration script?

January 17, 2014 1k views
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)
5 Answers
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.
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?
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.
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
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 :]
Have another answer? Share your knowledge.