Jump to content
  • 0

My SQL error


victorfa1

Question


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

Hello,

This errors is appearing when i click "RunServer"...

[/b][/color]: Acces denied for user 'root'@'localhost' <using password: YES>

[b][color=#00FFFF][Debub][/color][/b]: at ..\src\char\inter.c:788

I've read on this topic: http://rathena.org/b...-files-missing/ that i need to add privileges to my mysql root user... but how can i do it?

Thanks

@edit i can't run MySQL command Line ._.'

can i do it via windows prompt? =p

Edited by victorfa1
Link to comment
Share on other sites

7 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  123
  • Reputation:   4
  • Joined:  11/21/11
  • Last Seen:  

check your password xD

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

but how do i check my password?

when i open MySQL the password is not required '-'

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  123
  • Reputation:   4
  • Joined:  11/21/11
  • Last Seen:  

maybe your root account has no priviledges but it will be weird if your mysql is new installed xD or

you have have wrong passwords in the rathena server's config

you could do it via command prompt by typing

app.path/bin/mysql --user=root -p

H9deZ.png

try this GUI.

http://www.mysql.com...ucts/workbench/

select all the administrative roles, add a password

tybsj.jpg

Edited by mleo1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  25
  • Topics Per Day:  0.01
  • Content Count:  251
  • Reputation:   20
  • Joined:  12/22/11
  • Last Seen:  

u look doesnt configure correctly ur permisson for root..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  81
  • Topics Per Day:  0.02
  • Content Count:  1654
  • Reputation:   583
  • Joined:  08/09/12
  • Last Seen:  

\conf\char_athena.conf:

userid: username
passwd: password

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   593
  • Joined:  10/26/11
  • Last Seen:  

\conf\char_athena.conf:

userid: username
passwd: password

The user/pass in char_athena and map_athena are the user/pass that the char-server and map-server use to authenticate to the login-server. This is different than the MySQL user/pass, which is stored in inter_athena.conf

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

maybe your root account has no priviledges but it will be weird if your mysql is new installed xD or

you have have wrong passwords in the rathena server's config

you could do it via command prompt by typing

app.path/bin/mysql --user=root -p

H9deZ.png

try this GUI.

http://www.mysql.com...ucts/workbench/

select all the administrative roles, add a password

tybsj.jpg

Problem solved, Thanks.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...