MySQL

Creating a Database, User, and Granting Privleges

Submitted by Paulus on Fri, 03/11/2011 - 13:27

I always for get how to creat a database, user, and granting privileges to the new user for that database:

Resetting Locked Modx Account

Submitted by Paulus on Thu, 07/15/2010 - 15:24

If you can't remember what password you used to login into your modx site and got locked out, you don't need to wait until the system unblocks you from any further attempts.

Retrieving Plesk FTP Users Names and Passwords for Specific Domain

Submitted by Paulus on Tue, 07/14/2009 - 23:00

The following query will retrieve the sub-domain name, ftp username, and ftp password for a specific domain.
 
SELECT CONCAT(CONCAT(s.name, '.'), d.name) AS subdomain, u.login, a.password FROM subdomains AS s
JOIN domains AS d ON s.dom_id=d.id
JOIN sys_users AS u ON s.sys_user_id=u.id
JOIN accounts AS a ON u.account_id=a.id
WHERE d.name='example.com'
 
If you want to see all subdomains, then omit the WHERE clause.

Recovering Plesk Admin Password

Submitted by Paulus on Sat, 07/04/2009 - 18:35

In the highly unlikely event that you ever, for whatever reason forget your password to log into Plesk, one way of recovering the password is by loging into the server via SSH.
In order to view the contents of the file that contains the admin password you will need to be able to acquire root. Once root, you just simplely need to look at the /etc/psa/.psa.shadow file.
 
# cat /etc/psa/.psa.shadow
The$up3r$ecretPa$$w0rd

Syndicate content