![]() ![]() ( ! ) Notice: Undefined index: category_id in C:\xampp\htdocs\book_apps\ch05_guitar_shop\product_manager\index. The code seems to be correct but it is not creating users or databases in MySQL.Ĭreated the database "my_guitar_shop1" through PHPMyAdmin and now I get these errors with corresponding code just below each error message MySQL must be running as described in chapter 1.Įrror message: SQLSTATE Unknown database 'my_guitar_shop1' " The database must be installed as described in the appendix. There was an error connecting to the database. I created the user in PHPMyAdmin and gave it permissions and now I get the following error ![]() Rest the Folder structure \mysql\bin\ remains the same. Note that if you have any other installation directory, then you need to replace C:\XAMPP accordingly. Now type in the following command and hit enter: CD C:\xampp\mysql\bin. I am thinking there is something wrong with the XAMPP/MySQL that will not allow a connection to the database. This is downloaded from Murach's site so the code should be good. Even so, the 5th parameter of mysqliconnect() is the port, which is where it should be specified. ![]() Here are samples of the code that creates the database, the user and the password. If you look at your XAMPP Control Panel, its clearly stated that the port to the MySQL server is 3306 - you provided 3360.The 3306 is default, and thus doesnt need to be specified. I remember setting up a username and password during installation and I set up a username called "root" and a password through PHPMyAdmin yesterday but why will this application not run? I have searched and Googled and searched some more for the last two days but I can't seem to find a solution. However, the problem is still often a port conflict, which means that by now you should have a good idea on how to fix it. First here's what happens: The problem occurs when you change over from using phpMyAdmin with no password and mysql with no root password. Finally, sometimes XAMPP is not working due to an issue with MySQL, rather than Apache. Here's the solution to getting the 1045 Access denied for user 'root''localhost' (using password: NO) in phpMyAdmin. I downloaded XAMPP and it is running fine but for some reason I am unable to use the MySQL database. Select the rule from the list and click on the Enable button to start using it. Error message: SQLSTATE Access denied for user (using password: YES)" MySQL must be running as described in chapter 1. "Database Error There was an error connecting to the database. How to connect sql server to mysql (xampp). I am new to programming and I have been trying to run a PHP application from Murachs PHP and MySQL instructional book, the source code is actually from their website, but have been getting an error message. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |