Question

SQL databse access for registration script?

Posted January 17, 2014 2k 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)
Add a comment
andrewmf2011
By:
andrewmf2011

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
5 answers
kamaln7 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 Report
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 Report
kamaln7 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 Report
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 Report
kamaln7 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 Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help