|
||||||
|
First you login with mysql -u root -p and check the current policy rules by: # SHOW VARIABLES LIKE ‘validate_password%’; +————————————–+——–+ | Variable_name | Value | +————————————–+——–+ | validate_password_dictionary_file | | | validate_password_length | 5 | | validate_password_mixed_case_count | 1 | | validate_password_number_count | 1 | | validate_password_policy | MEDIUM | | validate_password_special_char_count | 1 […] dit the initial root password on install can be found by running grep ‘temporary password’ /var/log/mysqld.log http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html systemd is now used to look after mySQL instead of mysqld_safe (which is why you get the -bash: mysqld_safe: command not found error – it’s not installed) The user table structure has changed. So to reset the root […] [root ~]# mysql -u root ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password:NO) Stop the service/daemon of mysql running [root ~]# service mysql stop mysql stop/waiting Start mysql without any privileges using the following option; This option is used to boot up and do not use the privilege system of MySQL. [root ~]# […] MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it… Unfortunately the original MySQL documentation is much too complicated for my simple mind. So I did some testing and simplified it a bit for our customers… […] MySQL : interactive_timeout v/s wait_timeout Most of the database intensive applications are working about the default values of these variables obviously. Developers used to inform me that they need to extend the wait_timeout value in order to complete the query execution. After some googling, it is found that default “wait_timeout” value is good enough. […] How and Why You Should Change MySQL’s wait_timeout and interactive_timeout Variables wait_timeout variable represents the amount of time that MySQL will wait before killing an idle connection. The default wait_timeout variable is 28800 seconds, which is 8 hours. That’s a lot. I’ve read in different forums/blogs that putting wait_timeout too low (e.g. 30, 60, 90) […] Detailed MySQL basic commands Format: mysql -h host address -u user name -p User password 1, is connected to the machine on MYSQL. First, open a DOS window, then enter the directory mysql \ bin, then type the command mysql -u root -p, you lose the password prompt after the carriage return may or may […] Full Backup using MySQL Enterprise Backup As you might know, I am primarily an Oracle guy. This means that for all my backup needs, I am using Oracle Recovery Manager (RMAN). I recently had the task to implement MySQL Enterprise Backup for a MySQL database (mysql-advanced-5.6.15-linux-glibc2.5-x86_64). My most important resource for this task was […] Mysql Secure Installation for non default socket. SECURING MYSQL SERVER – mysql_secure_installation is a script useful to set root password disallowing root login remotely removing anonymous user accounts after first installation removing test database which can be accessed by any users Above script would work for default socket location i.e /var/lib/mysql/mysql.sock If the server […] mysql -u root -p use mysql update user set password=PASSWORD(‘abcde’) where user = ‘root’; mysql update user set password=PASSWORD(‘123456′) where user=’root’ mysqld -install
mysql> show variables like ‘char%’; mysql>set character_set_client=gbk; mysql>set character_set_results=gbk; |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments