Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Need Help on MySQL 5.0 and DBDesigner
August 17, 2006, 7:46 pm
rate this thread
I had MySQL 4.0.18 running as a service on my WinXP laptop, along with
MySQLAdministrator, and a new tool, DB Designer. Everything was working
fine, and I was able to do a good test.
Then I wanted to upgrade to MySQL 5.0. I completely uninstalled
everything with the "Add/Remove Programs" utility in the Control Panel.
I re-installed MySQL 5.0. I started it as a service, and I was able to
login just fine, and from a command line, create and edit databases and
I installed MySQL Administrator. Again, everything worked just fine.
Able to log in and log off, do all the stuff. Everything showed normal.
The service was running.
Then I reinstalled DB Designer, and the tool seems to have screwed up
my passwords. Now, I cannot log into MySQL using either the command
line OR MySQL Administrator.
I get error 1045 when I try it through MySQL Administrator, if that
I am pretty new to this, so any help needs to be REAL clear. Is there a
table in MySQL (with passords) that I need to reset or flush privileges
Re: Need Help on MySQL 5.0 and DBDesigner
This part seems what you require
If you try to connect as root and get the following error, it means
that you do not have a row in the user table with a User column value
of 'root' and that mysqld cannot resolve the hostname for your client:
Access denied for user ''@'unknown' to database mysql
In this case, you must restart the server with the --skip-grant-tables
option and edit your /etc/hosts file or \windows\hosts file to add an
entry for your host.
if all else fails re install
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum