Go to ...

Techpository

A Better Technical Repository

RSS Feed

Databases

Sybase: Hacking Sybase/MS-SQL for the NT Administrator

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.

MYSQL: Resetting the root user in MYSQL

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

MYSQL: Basic user setup

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››