mysql_secure_installation

 mysql_secure_installation - MariaDB Knowledge Base


mysql_secure_installation

MariaDB starting with 10.4.6

From MariaDB 10.4.6, mariadb-secure-installation is a symlink to mysql_secure_installation.

MariaDB starting with 10.5.2

From MariaDB 10.5.2, mysql_secure_installation is the symlink, and mariadb-secure-installation the binary name.

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

 mysql - ERROR 1698 (28000): Access denied for user 'root'@'localhost' - Stack Overflow


Some systems like Ubuntu, mysql is using by default the UNIX auth_socket plugin.

Basically means that: db_users using it, will be "auth" by the system user credentias. You can see if your root user is set up like this by doing the following:

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> SELECT User, Host, plugin FROM mysql.user;

+------------------+-----------------------+
| User             | plugin                |
+------------------+-----------------------+
| root             | auth_socket           |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+

As you can see in the query, the root user is using the auth_socket plugin

There are 2 ways to solve this:

  1. You can set the root user to use the mysql_native_password plugin
  2. You can create a new db_user with you system_user (recommended)

Option 1:

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ sudo service mysql restart

Option 2: (replace YOUR_SYSTEM_USER with the username you have)

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> CREATE USER 'YOUR_SYSTEM_USER'@'localhost' IDENTIFIED BY 'YOUR_PASSWD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'YOUR_SYSTEM_USER'@'localhost';
mysql> UPDATE user SET plugin='auth_socket' WHERE User='YOUR_SYSTEM_USER';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ sudo service mysql restart

Remember that if you use option #2 you'll have to connect to mysql as your system username (mysql -u YOUR_SYSTEM_USER)

Note: On some systems (e.g., Debian stretch) 'auth_socket' plugin is called 'unix_socket', so the corresponding SQL command should be: UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';

Update: from @andy's comment seems that mysql 8.x.x updated/replaced the auth_socket for caching_sha2_password I don't have a system setup with mysql 8.x.x to test this, however the steps above should help you to understand the issue. Here's the reply:

One change as of MySQL 8.0.4 is that the new default authentication plugin is 'caching_sha2_password'. The new 'YOUR_SYSTEM_USER' will have this auth plugin and you can login from the bash shell now with "mysql -u YOUR_SYSTEM_USER -p" and provide the password for this user on the prompt. No need for the "UPDATE user SET plugin" step. For the 8.0.4 default auth plugin update see, https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/



No need of sudo

The database is initialised with 2 all-privilege accounts: the first one is "root" which is inaccessible and the second one with your user name (check with command whoami).

To enable access to root account, you need to login with your user name

mysql -u $(whoami)

and manually change password for root

use mysql;
set password for 'root'@'localhost' = password('YOUR_ROOT_PASSWORD_HERE');
flush privileges;
quit

Login as 'root'

mysql -u root -p

Permission denied AH01275: Can't open directory for index:

 [username@localhost ~]$ chcon -R --reference=/var/www/html /home/username/folder1/folder2/

[username@localhost ~]$ sudo chcon -R --reference=/var/www/html /home/username/folder/folder2/

[username@localhost ~]$ sudo systemctl restart httpd


shell script to create user accounts

 shell script to create user accounts · GitHub


#!/bin/bash
ROOT_UID=0
SUCCESS=0
E_USEREXISTS=70
# Run as root, of course. (this might not be necessary, because we have to run the script somehow with root anyway)
if [ "$UID" -ne "$ROOT_UID" ]
then
echo "Must be root to run this script."
exit $E_NOTROOT
fi
#test, if both argument are there
if [ $# -eq 2 ]; then
username=$1
pass=$2
# Check if user already exists.
grep -q "$username" /etc/passwd
if [ $? -eq $SUCCESS ]
then
echo "User $username does already exist."
echo "please chose another username."
exit $E_USEREXISTS
fi
useradd -p `mkpasswd "$pass"` -d /home/"$username" -m -g users -s /bin/bash "$username"
echo "the account is setup"
else
echo " this programm needs 2 arguments you have given $# "
echo " you have to call the script $0 username and the pass "
fi
exit 0

How to create email account in postfix mail server

 http://www.bestdesigns.co.in/blog/create-email-account-postfix-mail-server

How to create email account in postfix mail server? (archive.org)

How to create email account in postfix mail server?

Ans :

Postfix configuration files are stored in “/etc/postfix”. The two main postfix configuration files are master.cf and main.cf, although we will only be dealing with main.cf  here.

First we are going to make some additions or changes to the main.cf configuration file. The following lines should be added, edited or uncommented:

The following are the main configuration for the postfix which is in the file “/etc/postfix/main.cf”

myhostname = mail.example.com
mydomain = example.com
myorigin = $mydomain
inet_interfaces = all
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
mynetworks = 192.168.0.0/24, 127.0.0.0/8
relay_domains =
home_mailbox = Maildir/

If postfix mail server is already  configure on your linux server and you want to create the new email account then you can do it by using following simple commands.

[root@office1 ~]adduser -s /sbin/nologin username;

[root@office1 ~]passwd username

Changing password for user username.
New UNIX password:

Enter the password twice and the email account is created. I have used “/sbin/nologin” in adduser command  means the user cannot login locally to the server, mail users have no need to ever login to the mail server.

Once the acount is created then you can able to send/receive emails username@example.com
The emails is stored in “/home/username/Maildir/” directory.
Done.

anti-pattern là gì

  Trong công nghệ và lập trình, Anti-pattern (mẫu phản diện) là những giải pháp bề ngoài có vẻ hiệu quả để giải quyết một vấn đề phổ biến, ...