Best way to store passwords in MYSQL database

The best way to store passwords in a MySQL database is to use a one-way hashing algorithm, such as bcrypt or scrypt, to hash the password before storing it in the database. This ensures that even if the database is compromised, the attacker will not be able to obtain the plaintext passwords. Additionally, it is also recommended to use a unique salt for each password to further increase security.