Need help with editing MySQL - Printable Version

Need help with editing MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Need help with editing MySQL (/showthread.php?tid=418167)

Need help with editing MySQL - LuisAlpaka - 23.02.2013

So when I open my server, my logs say i loaded everything fine except 3 mysql errors. These errors are fixable i'm guessing because these are the following errors.

Код:

[23:40:51] [MySQL] (Main Pipelines) Connecting to localhost...
[23:40:51] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host localhost - DB: ngrp_main - User: root
[23:40:51] [MySQL] Note: Make sure that you have provided the correct connection credentials.

Someone told me to edit it at the User Tabs on my PhPmyadmin, but i can't find something like that(I can see a usernames one? but it's not the problem...I think). If you know how, please respond here and PM me with info on how to fix this error. By the way, all the filterscripts and plugins load in fine.
Thanks,
Luis

Re: Need help with editing MySQL - MattSlater - 24.02.2013

Let's be honest here mate, stop attempting to create a server using the NGRP script.

I recommend nobody to help him here.

Re: Need help with editing MySQL - Cam - 24.02.2013

Step one:
Look at your navigation tabs near the top of your phpMyAdmin and select the option that says "Users"

Step two:
On the next page, click the link that says "Add User" under your current list of users.

You can then add all privileges and choose to have a password or not to have a password.

Afterwards, change the connection info in your script to your new username and password.

Hope this helped.

Re: Need help with editing MySQL - LuisAlpaka - 24.02.2013

Quote:

Originally Posted by Cam

Step one:
Look at your navigation tabs near the top of your phpMyAdmin and select the option that says "Users"

Step two:
On the next page, click the link that says "Add User" under your current list of users.

You can then add all privileges and choose to have a password or not to have a password.

Afterwards, change the connection info in your script to your new username and password.

Hope this helped.

Man, thanks for your response first of all. But my problem is that there is no users tab! I'm on kinj.net hosting and they provided me with this MySQL PhPmyadmin site: http://mysql.game.kingj.net/
If you could respond or something with how to get that users tab then I would greatly appriciate it.
Thanks,
Luis

Re: Need help with editing MySQL - 3ventic - 24.02.2013

Quote:

User: root

If you're on a hosting service, your username will NOT be root. Change the credentials in your script to match those given by your host.

Re: Need help with editing MySQL - LuisAlpaka - 24.02.2013

Quote:

Originally Posted by 3ventic

If you're on a hosting service, your username will NOT be root. Change the credentials in your script to match those given by your host.

Where would I change that in my script?

Re: Need help with editing MySQL - Cam - 24.02.2013

Are you able to access your phpMyAdmin config file?

Re: Need help with editing MySQL - yaron0600 - 24.02.2013

I'm Luis Partners but by what do u mean ? By the PHP ? Or something else ?