![]() New Line: $bindir/mysqld_safe -datadir=$datadir -pid-file=$server_pid_file $other_args >/dev/null 2>&1 & 8. Old Line: $bindir/mysqld_safe -skip-grant-tables -datadir=$datadir -pid-file=$server_pid_file $other_args >/dev/null 2>&1 & Open the mysql startup script and remove –skip-grant-tables as shown below. Update /etc/rc.d/init.d/mysql Startup Script and Remove –skip-grant-table Stop the mysql server using one of the following method. mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user='root' Set MySQL Root Password to a New Password Using UPDATE Commandįollow the strong password rules while setting new password for the mysql root account. Server version: 5.1.25-rc-community MySQL Community Server (GPL) You can turn off this feature to get a quicker startup with -A Reading table information for completion of table and column names Since you’ve skipped the grant table, this time when you try to login to mysql, it will not ask for password. Login Using MySQL Root User Without Entering Password Start the mysql server with skip-grant-tables option, which will allow anybody to login to mysql without entering a password. Start MySQL Server With –skip-grant-tables New Line: $bindir/mysqld_safe -skip-grant-tables -datadir=$datadir -pid-file=$server_pid_file $other_args >/dev/null 2>&1 & 3. Old Line: $bindir/mysqld_safe -datadir=$datadir -pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |