Search the Community
Showing results for tags 'sql'.
Found 3 results
I'm interested in producing a set of SQL queries for a few standard operations, like showing the total impressions for a given date range etc. Anyone done this (to save reinventing the wheel) or got some pointers please - starting with that example ;-) ???
I have been advised to change the password on my SQL database, in hopes of securing it (in case the hacker managed to snag that information). However, I can't seem to get the password to update. I've gone into phpMyAdmin inside my cPanel, and tried setting a new password. Then I changed the password in the config.php file. But I can't log in with the new password; however, the old password continues to work. I've tried setting up a new user with a new password, while removing the old user. After updating the config file, I couldn't log in with the new info, but I could still log in with the old info. I tried deleting the old user completely. After updating the config file, I still couldn't log in with the new info, but I could still log in with the old info. I tried importing the old database into a new database (with a new name), and creating a new user with a new password for the new database. After updating the config file, I couldn't log in with the new info, but I could still log in with the old info. What the frick am I doing wrong? Thank you. Eliz.