Databases
There are a few reasons that this task may fail, but one of the most common is the follow: In Maintenance Cleanup Tasks, check to make certain the file extension entered is bak and not .bak. Save your change and then test it. It is normal to put a “.” then the file type in
We were recently faced with getting into a Sybase database where we had fully authorized Administrator access to the NT system, but everybody who knew the “sa” password was long gone. We positively needed the data, so we found a way in, and we’re recording this here so we don’t forget how we did this.
To resolve this error do the following: mysql_upgrade -u root -p
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES) 1.stop mysql service with “service mysqld stop” 2.start mysql service with “/usr/local/mysql/bin/mysqld_safe –skip-grant-tables & ” 3.Login mysql with “mysql -u root -p” 4.These are finished in mysql command line: USE mysql; UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’; FLUSH PRIVILEGES; quit 5.restart mysql service with
Make a new user: CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; Grant privileges: GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’; Flush privileges: FLUSH PRIVILEGES; How To Grant Different User Permissions Here is a short list of other common possible permissions that users can enjoy. ALL PRIVILEGES- as we saw previously, this would allow a
Older Posts››