hab da was
[Only registered and activated users can see links. Click Here To Register...]
Quote:
If you forget the root password, here is how you can reset it.
Stop mysqld with this command:
Quote:
|
/usr/local/etc/rc.d/mysql-server.sh stop
|
WARNING: do not leave this option on for long. Only for when you need it. It by passes all usual mysql security.
Quote:
-Sg|--skip-grant-tables
This option causes the server not to use the privi-
lege system at all. This gives everyone full access
to all databases! (You can tell a running server to
start using the grant tables again by executing
mysqladmin flush-privileges or mysqladmin reload.)
|
Here is the line after I modified it in /usr/local/etc/rc.d/mysql-server.sh:
Quote:
|
/usr/local/bin/safe_mysqld --user=mysql --skip-grant-tables > /dev/null & && echo -n ' mysqld'
|
Connect to mysql
Quote:
Be cautious; this next step will reset the passwords for all root users. You may wish to restrict this SQL by including an "and host = 'something'" clause. Inspect existing users with the "SELECT host, user from user;".
Select the mysql database and reset the password.
This next step will reset the passwords for all root users. You may wish to restrict this SQL by including an "and host = 'something'" clause. Inspect existing users with the "SELECT host, user from user;".
Quote:
use mysql
update user set password = PASSWORD('secret') where user = 'root';
|
WARNING: Do not forget to undo that mysql bypass!
1. Stop mysql
2. Remove the option from the /usr/local/etc/rc.d/mysql-server.sh
3. Restart mysql: /usr/local/etc/rc.d/mysql-server.sh start
|
hab aber nur schnell geguckt weiß nich obs geht^^
Quote:
war das jz abwertent gemeint???
ich wolte nur helfen =(