Created
February 14, 2023 08:34
-
-
Save Max95Cohen/36abf269f698976004c6a01f7f97c827 to your computer and use it in GitHub Desktop.
mysql tips
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Kill sleeped connections | |
for i in `mysql -u root -e "show processlist" | awk '/Sleep/ {print $1}'` ; do mysql -e "KILL $i;"; done | |
MYSQL reset password | |
sudo systemctl stop mysql | |
sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" | |
sudo systemctl start mysql | |
sudo mysql -u root | |
UPDATE mysql.user SET authentication_string = PASSWORD('password'), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost'; | |
FLUSH PRIVILEGES; | |
exit | |
sudo systemctl stop mysqld | |
sudo systemctl unset-environment MYSQLD_OPTS | |
sudo systemctl start mysqld | |
sudo mysql -u root -p | |
Password Reset on Ubuntu | |
1. sudo mysql --defaults-file=/etc/mysql/debian.cnf | |
2. FLUSH PRIVILEGES; | |
3. ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; | |
4. exit; | |
5. sudo service mysql restart | |
Бір мәнді оқу үшін, алдында оны бос мәнге тексеру. Егер бос болса, орындамау. | |
HTML тэгтерден тазарту, htmlspecialchars(), strip_tags, trim. | |
Қайтадан бос мәнге тексеру. | |
Экранирование mysqli_real_escape_string($a_connect, $a_data); | |
substr(), (int); | |
[ Құпия сөзді сақтау ] | |
Құпия сөз + жасырын кілт + тіркелген мерзімі; | |
32 символдан тұрады. | |
cat .my.cnf | |
[mysqldump] | |
user=backup | |
password= | |
GRANT SELECT, PROCESS, LOCK TABLES, SHOW VIEW, TRIGGER ON *.* TO backup@localhost |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment