[PROBLEM] MySQL doesn't work

10/26/2012 15:43 Hesorio1u#1
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

[Only registered and activated users can see links. Click Here To Register...]

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:

[Only registered and activated users can see links. Click Here To Register...]
Thanks. :o
10/26/2012 17:57 freeskier4lif3#2
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.
10/27/2012 13:23 Hesorio1u#3
Sorry,
But u didn't help me anything!
10/27/2012 20:15 conquer93#4
why wud u want to do this ? if a normal local sql account works too ?
10/27/2012 20:50 Decima#5
Quote:
Originally Posted by Hesorio1u View Post
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.
10/27/2012 22:11 Hesorio1u#6
Well, Decima are u sure?
Take a look this picture:

Quote:
[Only registered and activated users can see links. Click Here To Register...]
10/28/2012 20:30 Decima#7
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 ;)
10/30/2012 03:56 FalconBay#8
Here is a good tutorial that you can go by:

[Only registered and activated users can see links. Click Here To Register...]

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.
10/30/2012 17:02 Decima#9
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. . . . . .
10/30/2012 21:51 FalconBay#10
Quote:
Originally Posted by Decima View Post
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.:pimp:
10/30/2012 22:13 Hesorio1u#11
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.
10/30/2012 22:48 FalconBay#12
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.
10/30/2012 23:30 Hesorio1u#13
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?

:*
10/30/2012 23:50 HellSpider#14
Quote:
Originally Posted by FalconBay View Post
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.:pimp:
No offense, but how do you plan to help people if you have no idea what they're trying to accomplish? :rolleyes:

Quote:
Originally Posted by FalconBay View Post
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.
10/31/2012 01:15 FalconBay#15
Quote:
Originally Posted by HellSpider View Post
No offense, but how do you plan to help people if you have no idea what they're trying to accomplish? :rolleyes:



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.