Dev {Tricks}

You are here: Home / Home

by

Transfer a domain from one user to another | DirectAdmin

Create new user with fake domain name, if the user does not exist. Then run below script.

cd /usr/local/directadmin/scripts
./move_domain.sh domain.com olduser newuser

domain.com = The domain you want to transfer
olduser = Current username of the domain
newuser = New username

NB: https://help.directadmin.com/item.php?id=58

by

How to create new Administrator user in OJS?

Find what the user group ID of Administrator group is by running:

SELECT user_group_id FROM user_groups WHERE context_id=0 AND role_id=1;

It’ll probably give a 1 back as a result. Then, you can grant that to user:

INSERT INTO user_user_groups (user_id, user_group_id) VALUES (278, 1);

where 278 is the user ID, and 1 is the user_group_id.

 

Reset admin password

UPDATE users SET password=SHA1(CONCAT(username,'w6Jdib4nNCZ')) WHERE username='admin';

 

 

by

Error connecting to MySQL: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

  • Error connecting to MySQL: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

Try restarting server first.

check for mysql Error

mysql -u root

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

Follow here

https://help.directadmin.com/item.php?id=332

To find all socket files on your system run:

sudo find / -type s

Add or edit mysql socket /etc/my.cnf. In my case, it is

socket=/var/lib/mysql/mysql.sock

Where is mysql

whereis mysql.sock