SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 11/07/2016, 09:46 PM   #1
bgedition
Huge Clucker
 
bgedition's Avatar
 
Join Date: Oct 2013
Location: 127.0.0.1
Posts: 417
Reputation: 37
Default MySQL pisses me off!

Hello,

So MySQL always gives me the same error #1045 - Access denied! with no reason.
When my server tries to connect to the localhost is showing this shitty error! I tried with different database usernames and always with correct passwords, but it just don't wants the server to connect!

please if someone knows what is wrong - let me know it!
__________________
Never point your finger at some one, you will always have three fingers pointing back at you.
bgedition is offline   Reply With Quote
Old 11/07/2016, 09:50 PM   #2
Naruto_Emilio
Banned
 
Join Date: Apr 2011
Location: North Africa
Posts: 1,297
Reputation: 365
Default Re: MySQL pisses me off!

- Stop MySQL
- Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables
- Now, open a new terminal window and run the MySQL client: mysql -u root
- Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; If you are using MySQL 5.7 (check using mysql --version in the Terminal) then the command is:
UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root';
- Flush the privileges with this MySQL command: FLUSH PRIVILEGES;
Naruto_Emilio is offline   Reply With Quote
Old 11/07/2016, 09:57 PM   #3
WhiteGhost
Guest
 
Posts: n/a
Default Re: MySQL pisses me off!

if it pisses u off,dont use it.
Do u like stress?
  Reply With Quote
Old 11/07/2016, 10:01 PM   #4
bgedition
Huge Clucker
 
bgedition's Avatar
 
Join Date: Oct 2013
Location: 127.0.0.1
Posts: 417
Reputation: 37
Default Re: MySQL pisses me off!

I have to use it! I mostly am using the mysql like a 'bridge' for my website and the server! so I must use it
__________________
Never point your finger at some one, you will always have three fingers pointing back at you.
bgedition is offline   Reply With Quote
Old 11/07/2016, 10:02 PM   #5
WhiteGhost
Guest
 
Posts: n/a
Default Re: MySQL pisses me off!

Oh,ik then well if u cant learn from samp tutorials view youtube tutorial.
Dont rush it,Take your time and learn it.
  Reply With Quote
Old 11/07/2016, 10:06 PM   #6
bgedition
Huge Clucker
 
bgedition's Avatar
 
Join Date: Oct 2013
Location: 127.0.0.1
Posts: 417
Reputation: 37
Default Re: MySQL pisses me off!

Oh come on I know how to do the basic that's all I need. But I don't know the reason for this error! I can't find it!
__________________
Never point your finger at some one, you will always have three fingers pointing back at you.
bgedition is offline   Reply With Quote
Old 11/07/2016, 10:16 PM   #7
bgedition
Huge Clucker
 
bgedition's Avatar
 
Join Date: Oct 2013
Location: 127.0.0.1
Posts: 417
Reputation: 37
Default Re: MySQL pisses me off!

nevermind I'm the supid one here I swiched the password with the schema
__________________
Never point your finger at some one, you will always have three fingers pointing back at you.
bgedition is offline   Reply With Quote
Old 15/07/2016, 06:15 AM   #8
Parallex
Gangsta
 
Parallex's Avatar
 
Join Date: Mar 2014
Posts: 556
Reputation: 64
Default Re: MySQL pisses me off!

Quote:
Originally Posted by bgedition View Post
I have to use it! I mostly am using the mysql like a 'bridge' for my website and the server! so I must use it
You are using that free 000 web host, right?
__________________
Spectre
LS:RP Administration Team
Parallex is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Plugin r39-2 Error: Can't connect to local MySQL server through socket Emre__ Scripting Help 10 30/07/2014 08:26 AM
[Tutorial] [VIDEO] MySQL ORM r38: How to pair GM with MySQL & creation of registration/connection system cArnasLT Tutorials 3 19/05/2014 02:08 PM
BlueG MySQL plugin - Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 10:56 AM
[Tool/Web/Other] MySQL DB Manager - Easily manage your MySQL databases with this remote application fiki574 Tools and Files 13 22/07/2012 09:41 AM
Fucking Prob pisses me Off Zohaib_Matrix Client Support 2 17/09/2010 10:35 AM


All times are GMT. The time now is 12:14 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.