I got the below error message when login in PhpMyAdmin even from the terminal: mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server This solution does not work : [mysql] skip-grant-tables I use Xampp on windows10
I've executed the copy table operation from PhpMyAdmin and it is taking too long (big table), and now the original and new table are not responding (I can browse the other tables in PhpMyAdmin) I think because maybe there is…
I have problem from my phpmyadmin . i dont know what happen but after i restart my pc , i cant acces phpmyadmin . my Phpmyadmin didnt have password . i start my XAMPP normaly and this Apache and Mysql…
MySQL was working fine and then for no reason I start getting this error whenever I open http://localhost/phpmyadmin/ I spent hours here trying to find solutions but all what I've tried did not work. can someone please help me? I…
Currently I can view the list of my database and putting them as Sub-menus of my site, in the database they are ordered as smallest to highest (by ID) this is the code I use to get the data on…
I have a clean new mysql database on my localhost, and also I have a project built on codeigniter PHP framework and have a copy of that project database. However, when I import the database into my clean new database…
I have a table "rota" where volunteers submit the shifts they are available. They can submit more than 6 shifts, but 6 is the minimum required. I want to see how many volunteers have selected each of the shifts, but…
Attendance Portal in PHP I am facing problem at Final Attendance Report Generation I'm stuck at the final stage of the Project: I have a Table- attendance, If a student is Present I mark it as 1 if absent 0.…
Replace in a videos table with a column URL with many different URL types. I use MariaDB 10.3 https://google.com/questions/ask?963 https://google.com/embed/57=66.88.028.10/i/03/077fsdf https://google.com/top57=66.88.028.10/i/03/077 https://video.net/emb.html?asdeen45dr57=66.88.028.10/i/03/07776/asdeen45dr57 https://video.net/fomdfk5f7s1f.html https://video.net/emb.html?qsfeen4gttv1=54.47.158.810/i/11/00036/qsfeen4gttv1 I need to delete part of a specific URL (delete all after =) and replace with…
I have two tables: “rota” (1) and “volunteer” (2). The first name and last name columns are in (2), but the shifts in (1). With the following query I am able to see the names of those who have submitted…