webdevdea Posted July 31, 2013 Share Posted July 31, 2013 Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /Applications/XAMPP/xamppfiles/htdocs/HeadfirstPHP/report.php on line 29 Error connecting to MYSQL serve line 29>>>>>>>>>>>$dcb = mysqli_connect('localhost','root', 'root', 'aliendatabase') or die('Error connecting to MYSQL server.'); Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/ Share on other sites More sharing options...
requinix Posted July 31, 2013 Share Posted July 31, 2013 mysqli_connect_error Your username or password is wrong. I can say that outright because you should NEVER connect to your database as root. Make a new user just for your PHP scripts. Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442834 Share on other sites More sharing options...
webdevdea Posted July 31, 2013 Author Share Posted July 31, 2013 Yeah that did not work it still has the same issue going on.. now I have a bunch of extra users in my php admin.. I am sure its a simple fix I just have no Idea how to do it.. I have looked at the php site and done everything it has suggested and it still is not working.. ?????? Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442838 Share on other sites More sharing options...
jazzman1 Posted July 31, 2013 Share Posted July 31, 2013 Open up the mysql console and run mysql_secure_installation and change the root password from there. Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442855 Share on other sites More sharing options...
webdevdea Posted July 31, 2013 Author Share Posted July 31, 2013 Console, do you mean the terminal or MAMP PHPMYADMIN? Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442859 Share on other sites More sharing options...
jazzman1 Posted July 31, 2013 Share Posted July 31, 2013 Console or terminal is just a program that gives you access to different "shells" on the same or not machine. That's my understanding about that Yea, open up a terminal and try to run this program-http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442861 Share on other sites More sharing options...
webdevdea Posted July 31, 2013 Author Share Posted July 31, 2013 when I put it in my terminal it says no such file, should I sudo it? Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442870 Share on other sites More sharing options...
jazzman1 Posted July 31, 2013 Share Posted July 31, 2013 Hm..... can you give me the output of: locate mysql_secure_installation Does your database server is up? Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442872 Share on other sites More sharing options...
webdevdea Posted July 31, 2013 Author Share Posted July 31, 2013 already loaded? Link to comment https://forums.phpfreaks.com/topic/280682-error-connecting-to-mysql-server/#findComment-1442874 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.