database

MySQL Error: : ‘Access denied for user ‘root’@’localhost’

by

Open and edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distribution. Add skip-grant-tables under [mysqld] Restart MySQL You should be able to log in to MySQL now using the below command mysql -u root -p Run mysql> flush privileges; Set new password by ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘NewPassword’; Go back to /etc/my.cnf and remove/comment skip-grant-tables Restart MySQL Now you will be able to login with the … Read more

ORA-00904: invalid identifier

by

Your problem is those pernicious double quotes. Oracle SQL allows us to ignore the case of database object names provided we either create them with names all in upper case, or without using double quotes. If we use mixed case or lower case in the script and wrapped the identifiers in double quotes we are … Read more

What is an MDF file? [closed]

by

SQL Server databases use two files – an MDF file, known as the primary database file, which contains the schema and data, and a LDF file, which contains the logs. See wikipedia. A database may also use secondary database file, which normally uses a .ndf extension. As John S. indicates, these file extensions are purely convention … Read more

MySQL Error: : ‘Access denied for user ‘root’@’localhost’

by

Open & Edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distro. Add skip-grant-tables under [mysqld] Restart Mysql You should be able to login to mysql now using the below command mysql -u root -p Run mysql> flush privileges; Set new password by ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘NewPassword’; Go back to /etc/my.cnf and remove/comment skip-grant-tables Restart Mysql Now you will be able to login with the new … Read more

MySQL Error: : ‘Access denied for user ‘root’@’localhost’

by

Open & Edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distro. Add skip-grant-tables under [mysqld] Restart Mysql You should be able to login to mysql now using the below command mysql -u root -p Run mysql> flush privileges; Set new password by ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘NewPassword’; Go back to /etc/my.cnf and remove/comment skip-grant-tables Restart Mysql Now you will be able to login with the new … Read more