My online text for the class uses xampp for the mysql chapter. I use mysql for a networking class at Bradley University in Peoria, IL.
#1045 ACCESS DENIED FOR USER 'ROOT'@'LOCALHOST' (USING PASSWORD YES) ON MAC WINDOWS 7
August 2018 21:12 XAMPP version: 3.2.2 Operating System: Windows 7 I have run out of ideas of things to change to resolve this. However, I still get the following "Port 3306 in use" message, even though I changed the port to 3308 to fix the supposed port conflict.Ģ:52:36 PM Attempting to stop MySQL app.Ģ:52:37 PM Status change detected: stoppedĢ:52:40 PM Port 3306 in use by ""C:\Program Files\MariaDB 10.2\bin\mysqld.exe" "-defaults-file=C:\Program Files\MariaDB 10.2\data\my.ini" "MariaDB""!Ģ:52:40 PM MySQL WILL NOT start without the configured ports free!Ģ:52:40 PM You need to uninstall/disable/reconfigure the blocking applicationĢ:52:40 PM or reconfigure MySQL and the Control Panel to listen on a different portĢ:52:40 PM Attempting to start MySQL app.Ģ:52:41 PM Status change detected: running I also set the port to 3308 in C:\Program Files\MariaDB 10.2\data\my.ini Note that I set the port in C:\xampp\mysql\bin\my.ini to 3308: However, starting MySQL, gives the following "Problem detected" message.īut then it shows mysql running, despite the supposed port conflict. The Control Panel shows port 3308 being used for MySQL. Still getting this access denied error trying to connect to mysql from the command line:Ĭ:\xampp\mysql\bin>mysql -user=root -passwordĮRROR 1045 (28000): Access denied for user (using password: YES) I have worn google out researching this problem tried everything suggested to no availĪny help much appreciated! I will even give you the rest of the day off! ccaptn Posts: 2 Joined: 23. So, root should be able to connect to the db!
GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY PASSWORD 'passroot' * confirmed that MySQL user root has all db access privileges: * in phpMyAdmin selected the table data and successfully exported it * created a db (gmap1), table, and loaded data to it * added a root password for root (default was no password) Get this error trying to connect from php script to MySQL DB: Installed XAMPP V3.2.2, running Apache & MySQL Warning: mysqli_connect(): (HY000/1045): Access denied for user password: YES) in C:\xampp\htdocs\dbconnect.php on line 8 (the mysqli_connect call) I know that I am not the first to post on this subject, but am having no luck with anything I have googled so far. Help! Getting No traction on a DB connection error!
0 kommentar(er)
