Posted on

show-create-grant-databases

Login
1. mysql -u myusername -p OR mysql (root user)
2. enter password
3. mysql> SHOW DATABASES;

Create&Drop database
1. mysql> CREATE DATABASE database_name;
1.1. mysql> CREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;
2. mysql> DROP DATABASE database_name;

Show grants
1. mysql> SHOW GRANTS;
1. mysql> SHOW GRANTS username;
Grant database - from root user
1. mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'username'@'localhost';

ALL PRIVILEGES: CREATE, DELETE DB etc
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';

p.s. always write ; at the end
https://linuxize.com/post/how-to-show-databases-in-mysql/
https://www.mysqltutorial.org/mysql-create-database/
Posted on

Migrate to other Database

php artisan migrate --database=db_connection_name
php artisan migrate --database=db_connection_name --seed
php artisan migrate:refresh --database=db_connection_name --seed
Posted on

add domain to zoho

1. Domains: add domain to zoho
2. Verify Domain:
a) serveriai.lt -> domain -> redaguoti zona -> add: @ TXT zoho-verification=zb11111111.zmverify.zoho.com
b) Wait 15min
c) on zoho click button: Verity by TXT
3. enter username, example: info ( info@mail.com )
4. Configure Email Delivery:
a) serveriai.lt red zona:
@ MX 10 mx.zoho.com.
@ MX 20 mx2.zoho.com.
@ MX 50 mx3.zoho.com.
b) press button MX Lookup
5. SPF/DKIM
a)SPF: serveriai.lt red zona:
@ TXT v=spf1 include:zoho.com ~all
b)DKIM: Proceed to Configure DKIM, serveriai.lt red zona:
<selector>._domainkey.<yourdomainname.com> TXT TXTValue(long generated key by zoho)

Verify

p.s.
can verify all actions from Domains page

Steps to add new Aliases:
Login to the Zoho Mail Control Panel.
Go to the Mail Accounts section.
Click on the user for whom you want to add an alias.
Go to the Mailbox Alias section, and click Add New Alias

https://www.zoho.com/mail/help/adminconsole/email-administration.html#alink1
——————————————————