| View previous topic :: View next topic |
| Author |
Message |
evilic0n
n00b
Joined: 24 Jun 2004
Posts: 53
Location: Newark, NJ, USA
|
 Posted: Thu Sep 23, 2004 9:23 am Post subject: is there any way to delete the mysql password list |
 |
|
I just installed myth tv and i'm trying to set it up. i have tried to install it before to no avail. now i'm up to the part where i'm trying to set up the myth tv database and users and it keeps telling me that my access is denied.
| Code: | # mysql --user=root mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO
|
sometimes it even tells me that i am "Using password"
| Code: | # mysql --user=root -p randompassword
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) |
so what i want to know is if there is a way to bypass this password or is there a password file that can be modified /deleted ....
i just want to record some smallville  .. help[/code]
_________________
And in the end the Red Death held dominion over all. |
|
| Back to top |
|
 |
orb9
Tux's lil' helper
Joined: 02 Sep 2002
Posts: 82
Location: Germany
|
| Posted: Thu Sep 23, 2004 9:53 am Post subject: |
|
|
There is an option for the mysqld to not use the privilege system, which i used to fix some problems with my DB users:
--skip-grant-tables
This option causes the server not to use the privilege 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 a mysqladmin flush-privileges or mysqladmin reload command, or by issuing a FLUSH PRIVILEGES statement.)
This is from:
http://dev.mysql.com/doc/mysql/en/Server_options.html
Hope this helps!
_________________
"Without music, life would be a mistake - I would only believe in a god who knew how to dance." (Nietzsche) |
|
| Back to top |
|
|
evilic0n
n00b
Joined: 24 Jun 2004
Posts: 53
Location: Newark, NJ, USA
|
| Posted: Thu Sep 23, 2004 10:09 am Post subject: :( |
|
|
| Code: | # mysqladmin reload
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
# mysqladmin flush-privileges
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
|
_________________
And in the end the Red Death held dominion over all. |
|
| Back to top |
|
|
orb9
Tux's lil' helper
Joined: 02 Sep 2002
Posts: 82
Location: Germany
|
| Posted: Thu Sep 23, 2004 11:05 am Post subject: |
|
|
Assuming you have root access to your box, do:
| Code: | | $> /etc/init.d/mysql stop |
Then start the mysql daemon manually
| Code: | | $> mysqld --skip-grant-tables |
You should now be able to use mysqladmin (or other tools) without authentication. This means everybody has full access to ALL databases.
If you're working locally you can additionally prohibit network connections during the unprivileged period:
| Code: | | $> mysqld --skip-grant-tables --skip-networking |
When you're finished you should do
| Code: | | $> mysqladmin reload |
again to reactivate the privileges. Alternatively you can kill the demon by hand and restart it using the init scripts.
| Code: | | $> /etc/init.d/mysql start |
_________________
"Without music, life would be a mistake - I would only believe in a god who knew how to dance." (Nietzsche) |
|
| Back to top |
|
|
|
Multimedia
