by dev
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.
UPDATE users SET password=SHA1(CONCAT(username,'w6Jdib4nNCZ')) WHERE username='admin';
by dev
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
by dev
Download and install PuTTY on your computer.
After installing putty, run PuTTYgen from start menu
You may customize Parameter at the bottom. But generally default values are appropriate.
Now click on Generate and move the mouse on blank area to complete key generation.
Save private key in save place. Noted that you may or may not use Key passphrase.
Close PuTTYgen tools.
Connect to server with Private Key
Open PuTTY
Put hostname or IP in session.
Go to Connection > SSH > Auth and browse private key.
Now you will be prompted Login as
by dev
Incoming mail server (POP3 or IMAP):
mail.domain.com
Server hostname can also be used as mail server. For example, server.bdhostit.com
IMAP Settings:
Server requires encrypted connection (SSL). (Apple Mail users should tick “Use SSL”)
POP3 Settings:
Server requires encrypted connection (SSL). (Apple Mail users should tick “Use SSL”)
Username: EMAIL ADDRESS
Password: EMAIL PASSWORD
Outgoing mail server (SMTP):
mail.domain.com
Server hostname can also be used as mail server. For example, server.bdhostit.com
SMTP Settings
Username: EMAIL ADDRESS
Password: EMAIL PASSWORD
by dev
Redirect entire website to any other domain
301 (Permanent) Redirection
Redirect 301 / http://hostbriz.com/
302 (Temporary) Redirection
Redirect 302 / http://hostbriz.com/
Redirect file to a specific file/domain/directory/folder
Redirect file to domain
Redirect /index.html https://healthproclub.com/
Redirect old file path to new file path
Redirect /olddirectory/oldfile.html http://example.com/newdirectory/newfile.html
Redirect /old to /new directory
RewriteRule ^old/(.*)$ /new/$1 [R=301,NC,L]
Set the default index extension
DirectoryIndex index.html
Set redirect except condition RewriteCond
Options +FollowSymLinks
RewriteEngine on
RewriteCond %{REQUEST_URI} !^/index.php
RewriteCond %{REQUEST_URI} !^/fss
RewriteRule (.*) https://journals.healthproclub.com/$1 [R=301,L]
Redirect 404 Error pages to homepage
ErrorDocument 404 https://bdhostit.com/
Redirect non-existing page(s) to index.php
Options +SymLinksIfOwnerMatch
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
Redirect everything to https://hostbriz.com
RewriteEngine on RewriteRule ^(.*)$ https://hostbriz.com/$1 [R=301,L]
Redirect a directory to
RewriteRule ^journal/(.*)$ https://hostbriz.com/$1 [R=301,NC,L]
Redirect all sub domains to main domain with www
RewriteCond %{HTTP_HOST} ^[^.]+\.[^.]+$
RewriteCond %{HTTPS}s ^on(s)|
RewriteRule ^ http%1://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
Redirect all sub domains to main domain without www
RewriteCond %{HTTP_HOST} ^[^.]+\.[^.]+$
RewriteCond %{HTTPS}s ^on(s)|
RewriteRule ^ http%1://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
Redirect www, non-www, http to https without www
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteCond %{HTTP_HOST} ^(?:www\.)?(.*)$ [NC]
RewriteRule (.*) https://%1%{REQUEST_URI} [L,R=301]