[PROBLEM] MySQL doesn't work

~~Hesorio1u~~ · 10/26/2012, 15:43

Dear, Elitepvpers!

First:

I downloaded and installed MySQL (FULL)
The problem is with creating dedicated host to MySQL
When i try create dedicated host MySQL server, they droping me error!

[ERROR]

Quote:

The 'HOST' is not allowed to connect MySQL server

I try many solutions:

[SOLUTION]

Quote:

CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;
mysql> CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> CREATE USER 'dummy'@'localhost';

Is there any tutorial how to fix it? Cuz my vote page is not working, also some my script's on website...

I need dedicated MySQL database.

Will my dedicated site will work with local myssql connection?

+ I can connect & create LOCAL mysql server but i can't inert query's & Importing data.

ERROR - LOCAL CONNECTING

Quote:

ERROR 1044: Access denied for user ''@'localhost' to database 'vote'

SQL Statement:

Thanks.

freeskier4lif3 · 10/26/2012, 17:57

Your access denied message is saying that you're trying to connect without a user name "@localhost" is a blank user name. Try and fix where you're sending the username to connect and make sure you're adding that username to the connection string.

~~Hesorio1u~~ · 10/27/2012, 13:23

Sorry,
But u didn't help me anything!

conquer93 · 10/27/2012, 20:15

why wud u want to do this ? if a normal local sql account works too ?

Decima · 10/27/2012, 20:50

Quote:

Originally Posted by Hesorio1u

Sorry,
But u didn't help me anything!

well, he did actually

ERROR 1044: Access denied for user ''@'localhost' to database 'vote'

you have no username going with the @localhost, notice it only says '@localhost' ?

should say 'username@localhost' and username should be the username u use to login to mysql, you are not passing a username, therefore, access is denied

no username == no access

not sure i can dumb it down any further than that, sorry.

~~Hesorio1u~~ · 10/27/2012, 22:11

Well, Decima are u sure?
Take a look this picture:

Quote:

Decima · 10/28/2012, 20:30

ok, this time its different, becus it says 'newmysql'@'localhost'

its not giving that user access to w/e database you are trying to connect to, dbl check ur password for that user, and dbl check that it has permission to access the database you are trying to connect to, connecting locally these are the only 2 reasons why you would not be able to connect

FalconBay · 10/30/2012, 03:56

Here is a good tutorial that you can go by:

Don't install SQL Server 2012 because 2012 cannot read the older SQL server files and I do not have the knowledge to fix the files so that it can be read for SQL 2012 server.

Decima · 10/30/2012, 17:02

maybe you should actually read the topic b4 you post?

or even the title?

he is having problems with MySQL, not MSSQL, you have been here since 2008 i would expect that you know you should read the topic before replying to it. . . . . .

FalconBay · 10/30/2012, 21:51

Quote:

Originally Posted by Decima

maybe you should actually read the topic b4 you post?

or even the title?

he is having problems with MySQL, not MSSQL, you have been here since 2008 i would expect that you know you should read the topic before replying to it. . . . . .

How old are you? So what if I joined in 2008. I don't come on this site much and I don't come on just to flame at people like you. If he follows the procedure he won't have any problems creating the server. So before you use your fingers to type ... think twice before you do actually type. I'm not here to flame at anyone .. just trying to see if I could help out that's all.

~~Hesorio1u~~ · 10/30/2012, 22:13

Acctually, u didn't read a topic... U just post it because u need some points for posting.

Sorry, but u didn't helped me.

And i agree with Decima.

FalconBay · 10/30/2012, 22:48

It's a guide to go by that's all I'm saying. You can just download SQL Server 2008, install then just configure your ODBC and connect to your SQL Server.

~~Hesorio1u~~ · 10/30/2012, 23:30

LoL, i don't need MMSQL... its easy. My problem is configuring MySQL ( New version ) There is some error's what i just can't think how to fix. The guide what you post'ed is not useful. U don't need to post somewhere post's about it, if people do not discuss on this topic.

Thanks anyway, have anyone figured how to fix that problem?

:*

HellSpider · 10/30/2012, 23:50

Quote:

Originally Posted by FalconBay

How old are you? So what if I joined in 2008. I don't come on this site much and I don't come on just to flame at people like you. If he follows the procedure he won't have any problems creating the server. So before you use your fingers to type ... think twice before you do actually type. I'm not here to flame at anyone .. just trying to see if I could help out that's all.

No offense, but how do you plan to help people if you have no idea what they're trying to accomplish?

Quote:

Originally Posted by FalconBay

It's a guide to go by that's all I'm saying. You can just download SQL Server 2008, install then just configure your ODBC and connect to your SQL Server.

This thread has nothing to do with MSSQL.

FalconBay · 10/31/2012, 01:15

Quote:

Originally Posted by HellSpider

No offense, but how do you plan to help people if you have no idea what they're trying to accomplish?

This thread has nothing to do with MSSQL.

Sorry for my illiteracy but I just don't like the fact that someone has to flame another over a small misunderstanding. I was never a software person but I'm just slowly learning like others.