alexandre

is this already on my laptop or i have to download that tool?

oh and i just read the link you shared and sadly i have no way to buy a legitimate antivirus to make a full scan of my computer.. i was hoping that this antivirus was just trying to scare me by showing me a scary threat but i am still unsure about what this is about. also it is probably infected since for xamp to work fine i has to disable my computer UAC

this message is coming from avast free antivirus. i has trusted avg before but i normally dont even trust any antivirus at all.

i was wondering if this is an actual threat or simply the marketing method of all antivirus.. this keeps spamming every 3 or 5 minutes so i want to be sure because this antivirus doesnt give me an option to fix it , it just abort the connection to the infected thing and ask me to upgrade my protection... if anyone is familiar with that i would apreciate an advice.

i am so stupid sometimes .... i simply didnt reopened the new folder in my workspace so i was updating the old files .... and thank you for your devotiuon , i appreciate.

the only database names present are the default ones and my new database

i honestly dont know where you want me to do this query.. i am connected on phpmyadmin and i can do whatever i want but when it comes to connect via php this is where it is using the previous database name for no reason apparently. and i jut did the query in the sql section and it is showing my actual database.

would it be posible that since i did not delete the previous database htdocs folder and since i am using the same user login info it might interfere between the two instances ?

the problem doesnt seem to come from the name but effectively from the connection, just as if the server was trying to connect to the new database with the previous name kept in cache or something, because the name i put in DATABASE_NAME is the correct and the database exist i just created it but couldnt register the first user using my register page. so i changed the connection file to the right database info but it never changed anything.

i guess the error log that gets the closest to your definition seems like this : [Mon Oct 31 11:09:58.158903 2022] [ssl:warn] [pid 16932:tid 420] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name [Mon Oct 31 11:09:58.483892 2022] [ssl:warn] [pid 16932:tid 420] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name [Mon Oct 31 11:09:58.738894 2022] [mpm_winnt:notice] [pid 16932:tid 420] AH00354: Child: Starting 150 worker threads. [Mon Oct 31 12:09:02.998050 2022] [php:error] [pid 16932:tid 1908] [client ::1:61307] PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES) in C:\\xampp2\\htdocs\\container\\phplogin\\registration\\connect_db2.php:8\nStack trace:\n#0 C:\\xampp2\\htdocs\\container\\phplogin\\registration\\connect_db2.php(8): mysqli_connect('localhost', 'root', '', 'phplogin')\n#1 C:\\xampp2\\htdocs\\container\\phplogin\\registration\\register.php(3): include('C:\\\\xampp2\\\\htdoc...')\n#2 {main}\n thrown in C:\\xampp2\\htdocs\\container\\phplogin\\registration\\connect_db2.php on line 8, referer: http://localhost/container/phplogin/registration/register.html

sorry but i never heard of http/error log is this something i am capturing with this error code in the file above?

i completely started over in a new folder after uninstalling so unless there is something in the config that have stayed the same as before and is defining my variable DATABASE_NAME as my previous database name, i dont see what could do that.. $DATABASE_HOST = 'localhost'; $DATABASE_USER = 'root'; $DATABASE_PASS = ''; $DATABASE_NAME = ''; mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); $con = mysqli_connect($DATABASE_HOST, $DATABASE_USER, $DATABASE_PASS, $DATABASE_NAME); if (mysqli_connect_errno()) { // If there is an error with the connection, stop the script and display the error.// exit('Failed to connect to MySQL: ' . mysqli_connect_error()); } ?> this is my db connection file everything was working fine before i messed up my database and now it is acting as if there was cookies keeping this wrong name

as i said phplogin was the name of the previous database from before i uninstalled xamp because i had locked my root user account... the name is updated to my actual db name in my databse connection file that i use on every pages so it should normally work but it isnt ..

i restarted a database and updated my db connection file which connect to the database but for some reason i get this error: Fatal error: Uncaught mysqli_sql_exception: Unknown database 'phplogin' in C:\xampp2\htdocs\container\phplogin\registration\connect_db2.php:8 Stack trace: #0. i emptied my cookies from any time and it still doesnt update. it is reading the old database name, the one i lost after uninstalling but i did not made the erase of the htdocs folder. i dont know if it might be a problem but the new xamp is installed in another folder in the same directory so i wonder if it might be the issue.. apart of that i know for sure that the database exist and the name is spelled right so this isnt the issue here.

finally i am going to redo the whole database i would already be done with this if i wasnt always messing around.. my logic isnt the best as i only has about 7 tables in the database. but thank you for the help if i knew what i am doing maybe i could have fixed it.

for some reason it seems that using xamp is giving me a different path for this C:\> cd "C:\Program Files\MySQL\MySQL Server 8.0\bin" the path in xamp to mysql is totally different , so i am not sure where to look right now.

ok i will try to launch my pc in safemode but i guess there is a way to get in my account by using the terminal and do it directly in the command line? when i tried using the terminal of the xamp control panel it didnt recognized the skip grants command as a command so thats why i was wondering if i could actualy do it with xamp. the only other solution i have found online was to uninstall xamp and reinstall then i would have to redo my whole database...

thank you for your answer , i just have one question here. do i have to remove the user authentificattion somehow ? i see that the manual is for resetting the root password but thats not the password that is wrong in my case simply the root accounts are locked. also if i have to do a manipulation with the terminal is it doable the same way when using xamp?

MySQL said: Cannot connect: invalid settings. mysqli::real_connect(): (HY000/4151): Access denied, this account is locked Connection for controluser as defined in your configuration failed. mysqli::real_connect(): (HY000/1045): Access denied for user '127.0.0.1'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

hackers got me so paranoiac that every new privileged accounts that i forgot or nerver saw before , i lock them but this time, it seems like i hit my own acount and i locked myself out usually i was able to get back in by changing the config file for the password but the fact that i literally locked the users account its telling me that all my accounts are locked . i tried every users that i has and each of them are locked. so now i am kinda lost on how to get back in at least my main root user.. any help would be appreciated.

i was looking at this cron jobs and i dont think it would be useful for what i have in mind, since there is a limitation of 60 sec as shortest interval betweens each jobs. if i see my platform as a high traffic website. users wont be limited in time between each transaction they want to do so, i dont think it would work. but for other things it might come in handy.

i am kinda slow to understand but i think my issue here except for the automatic refresh issue. my problem with the database not actualizing on refresh is simply that i did not separate my script , i should have made a script only on server side processing the winners rows instead of doing it on the actual event ranking page.

i was wondering if it would be possible or even too annoying for the user to force a redirection to where the action is taking place. this way if an event is starting, the user could maybe get notified of the imminent redirection and then have a choice to close the popup to cancel the redirection if they wish to finish something they was doing in the moment. i noticed that for the first events i coded , it seem to be made in a way that, only when the user visit the event page, the database gets updated. by that i mean that even if i refresh when i am in the profile page the statistics supposed to be updated doesnt actualy upate until the user go to the event page.

thank you for the advice i will look into what is cron job.

ok thank you, i am indeed trying to make example : the user balance updating if an event is starting and they are not logged on or on another page than the actual event page.