Search the Community

Dear Larry, I started learning MySQL through your book. To get started, I followed you instruction to set a password to the root using MyPhpAdmin. After I have entered the password, I updated the config.inc.php file to include the password. However, I am no longer able to access the root ever since. The error message is 1045, Access denied for user root@local host (using password:YES). I researched the web for password reset but the techniques (MySQLD) could not resolve my problem. Could you advise what I can do. Thank you so much.

For some years I have used a server when developing php scripts but now need to use resident php/MySQL on my laptop. I have changed passwords as instructed on pp 594 using phpMyAdmin from the Control Panel, and in config.inc.php. Oddly, MySQL allows me into tables and the like but now refuses access to the home page:... localhost / phpmyadmin / index.php?db=db etc. etc. Any explanation? (Spaces are to prevent the forum from creating a link) I have installed the whole kaboodle via Apache friends and php scripts work fine. However, when I use the 1and1 server, I can program it to automatically look at a subdirectory (e.g. main/index.php) when a URL is called (e.g. www.sonningmowers.com). The question is - how can I do that in php on the laptop? Is it the line in config.inc.php: $cfg['Servers'][$i]['user'] = 'root'; and should I change it to: $cfg['Servers'][$i]['user'] = 'main/root';...or the like? Thanks for the support.