MySQL Error 1044

[iSnuggle]

I got MySQL 5 on my Computer, and whenever i try to get into the admin browser or query browsers it errors me with 1044. tried reinstalling it and deleting the files and stuff, ive looked on net but cant find anything,

If someone can help it will be much appreciated :D

Josh

[MentaL]

[Yetsuki]

What's the error message? You sure MySQL is even running?

[iSnuggle]

I'll take a screenie for you

[Yetsuki]

Server's not running...
Go to Start -> All Programs -> MySQL -> System Tray Monitor

A tray icon should pop up, right click it, and click "Start Instance".

If that doesn't work, then the ports blocked. Or you changed the default port which you shouldn't have...

[iSnuggle]

Okay, so i did as u asked. but its still giving me 1045..

'ragnarok'@'localhost' (using password: yes)

[Omnija]

u obviously didint put in the right username or password

usually user is root and w/e password u put in

[Yetsuki]

Nah, go into MySQL Admin, go to "Users" on the left, click on "ragnarok" in the bottom left box. Now click the "Schema Privileges" tab and click on the "ragnarok" database in the left column. Now click the "<<" button and it should give user "ragnarok" all access on "ragnarok" database.

EDIT: If you can't get into MySQL admin, you need to use the user "root" and whatever pass you entered when configuring your MySQL server.

[iSnuggle]

I did that, didnt work. So i reinstalled mysql and redid it and when i got to start my server it doesnt connect to the database.

[Jayson]

Teamviewer?
I'll try to help you ;)

[iSnuggle]

Im just downloading it now. I got no idea how to use it tho ><

[Jayson]

Uhm , do you have a msn ?

[iSnuggle]

Yeah, joshua_adlington@hotmail.com

Anyone add me if they can help me.

[asreinna]

error 1044 means that u not have the privileges to create a database...
try uninstall then reinstall it with another password...
if not working then refer to the manual in MySQL Query Analyzer - Improving SQL Query Performance

[iSnuggle]

It all fixed now. After weeks..

[asreinna]

good to you...the key is "NEVER GIVE UP"