Wamp phpmyadmin password11/14/2023 ![]() ![]() Now here's the part where I want to stick my head through the monitor! When I try to access the phpbb, I get the message " phpbb critical error cannot connect to database" I checked and double checked all that i've read here as well as everywhere else that google will allow me to check. I also edited the phpMyAdmin config.inc file to reflect the changed password for the root account. Mysql>update er SET password=password("newpassword" hit enter However, as we know, this is not very secure so I changed the root password by performing the following from the console: I cleared the cache, tried again and was able to install it when I used the root user and password. I copied the phpbb directory into the When I tried to run the installation for phpbb I got the message about the not being able to connect. From my understanding, the default user for phpmyadmin and sql is "root" with NO password. Remove the 'skip-grant-tables' parameter we added earlier.ĭO NOT Leave this parameter in the ini file its a HUGH security hole.First let me point out that I am fairly new to mysql and php. Now enter 'quit' at the mysql command promt to exist mysql.ġ0. ![]() Note that the update should report that it has updated more than one row, that because there are actually 3 user accounts with the userid of 'root' each with a different domain i.e. UPDATE er SET Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y', Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y', Create_tablespace_priv='Y' WHERE User='root' (Given the length of the first line, it is necessary to perform copy / paste). Reassign all privileges to root : enter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql. ![]() UPDATE er SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root' Ħb. UPDATE er SET Password=PASSWORD('MyNewPass') WHERE user='root' Now we are going to reset the password for the root user, of course this could be used to reset any users password.Įnter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql. Wampmanager -> MySQL -> Service -> Start/Resume ServiceĦa. Find the or section in the ini fileĪdd this line directly after the section or Wampmanager -> MySQL -> Service -> Stop Serviceģ. The Windows session must be administrator and Wampserver started as administrator. If you have set a password for the root user, but you have forgotten it, or you accidentally deleted all with root privileges, you can choose a new password and re-allocate privileges the following procedure in Windows: Yhis is because for MySQL version since 5.7.0 the column name is changed. ERROR 1504 (42S22) : Unknown column 'password' in the 'field list'. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |