ArcEmu: Unable To Connect To Mysql Server. Mysql Reported: Mysqlnd Cannot Connect To Mysql 4.1+ Using Old Authentication. - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Unable To Connect To Mysql Server. Mysql Reported: Mysqlnd Cannot Connect To Mysql 4.1+ Using Old Authentication.

#1 User is offline   kcirrab 

  • Newbie
  • Group: Members
  • Posts: 4
  • Joined: 16-January 12
  • Gender:Male
  • Server OS:Windows

Posted 18 January 2012 - 02:07 AM

When I make the account creation page for the server and link all of the code to my server it loads up ok but i get error

"Unable to connect to MySQL server. MySQL reported: mysqlnd cannot connect to MySQL 4.1+ using old authentication."

Help Please
0

#2 User is offline   Dzjhenghiz 

  • حشّاشين
  • Group: Contributor
  • Posts: 1,936
  • Joined: 07-June 08
  • Gender:Male
  • Location:2nd stone after the 3rd oase western sahara
  • Interests:M.C.S.E :- Minesweeper Consultant & Solitaire Expert
  • Server OS:Other

Posted 18 January 2012 - 04:35 AM

Might be the answer ; Click ?

Else i bet Something Usefull between these..
Need Help With Arcemu ? ^^
Posted Image
Concordia res parvae crescunt In varietate concordia
Spoiler

0

#3 User is offline   Andragon 

  • Member
  • Pip
  • Group: Members
  • Posts: 70
  • Joined: 02-January 12
  • Gender:Male
  • Server OS:Windows

Posted 18 January 2012 - 06:53 AM

View Postkcirrab, on 18 January 2012 - 02:07 AM, said:

When I make the account creation page for the server and link all of the code to my server it loads up ok but i get error
"Unable to connect to MySQL server. MySQL reported: mysqlnd cannot connect to MySQL 4.1+ using old authentication."

You have to write more in details what you are doing. Post some of your PHP code for example. I guess you are using PHP ? Questions ... Questions ...
And maybe also better to update your mySQL engine to 5.2.
Posted Image
Join our new public ArcEmu
developer server project. Please visit our website at dev.LandOfElves.net and share the knowledge of ArcEmu servers !
Mach mit bei einem neuen ffentlichen ArcEmu Server fr Entwickler. Besuche dev.LandOfElves.net und tausche Dich mit anderen Mitgliedern aus.

0

#4 User is offline   kcirrab 

  • Newbie
  • Group: Members
  • Posts: 4
  • Joined: 16-January 12
  • Gender:Male
  • Server OS:Windows

Posted 18 January 2012 - 09:24 PM

Here is the index im using for the website, and i am currently running mysql 5.5

Spoiler

0

#5 User is offline   Rigamaru 

  • Member
  • Pip
  • Group: Members
  • Posts: 18
  • Joined: 02-August 11
  • IRC:Rigamaru
  • Gender:Male
  • Location:USA
  • Server OS:Windows

Posted 18 January 2012 - 09:31 PM

First, connect to the MySQL database with an older client that doesn't mind old_passwords. Connect using the user that your script will be using.

Run these queries:

SET SESSION old_passwords=FALSE;
SET PASSWORD = PASSWORD('[your password]');
In your PHP script, change your mysql_connect function to include the client flag 1:

define('CLIENT_LONG_PASSWORD', 1);
mysql_connect('[your server]', '[your username]', '[your password]', false, CLIENT_LONG_PASSWORD);


Source: http://stackoverflow...-authentication

Also:


1.Set old_passwords=0 in my.cnf file
2.Restart mysql
3.Login to mysql as root user
4.Execute FLUSH PRIVILEGES;

Don't know if it helps.
0

#6 User is offline   kcirrab 

  • Newbie
  • Group: Members
  • Posts: 4
  • Joined: 16-January 12
  • Gender:Male
  • Server OS:Windows

Posted 18 January 2012 - 10:18 PM

View PostRigamaru, on 18 January 2012 - 09:31 PM, said:

First, connect to the MySQL database with an older client that doesn't mind old_passwords. Connect using the user that your script will be using.

Run these queries:

SET SESSION old_passwords=FALSE;
SET PASSWORD = PASSWORD('[your password]');
In your PHP script, change your mysql_connect function to include the client flag 1:

define('CLIENT_LONG_PASSWORD', 1);
mysql_connect('[your server]', '[your username]', '[your password]', false, CLIENT_LONG_PASSWORD);


Source: http://stackoverflow...-authentication

Also:


1.Set old_passwords=0 in my.cnf file
2.Restart mysql
3.Login to mysql as root user
4.Execute FLUSH PRIVILEGES;

Don't know if it helps.


assuming I know nothing. how do I do this? like what program doesnt mind old passwords how do i go about it.. where is my my.cnf file?
How do i flush privledges? how do I login as root? etc.
0

#7 User is offline   Rigamaru 

  • Member
  • Pip
  • Group: Members
  • Posts: 18
  • Joined: 02-August 11
  • IRC:Rigamaru
  • Gender:Male
  • Location:USA
  • Server OS:Windows

Posted 18 January 2012 - 10:20 PM

View Postkcirrab, on 18 January 2012 - 10:18 PM, said:

assuming I know nothing. how do I do this? like what program doesnt mind old passwords how do i go about it.. where is my my.cnf file?
How do i flush privledges? how do I login as root? etc.

Well you log into your DB using HeidiSQL or Navicat and you write SQL scripts.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users