MySQL refusing to accept passwords
Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL 5.5.13. This morning, all was working well. This evening, I launched MySQL Workbench 5.2.34 CE to work on a table. When I attempt to access the server from within Workbench, I'm now prompted with a window asking for my password. Of course, my password is not accepted when I enter it - I'm presented with error #2000. Just to confirm, mysql --version returns: mysql Ver 14.14 Distrib 5.5.13, for Win64 (x86) This is not an upgrade, after my last mishap, I once again formatted the laptop with a fresh install of Windows 7 Ultimate 64-bit as well as MySQL 5.5.13. I've begun digging through bugs.mysql.com, but I'm not seeing any standing out. I should point out that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happening every month or so at this point. Thanks in advance, -Tim Thorburn
RE: Next Unique Number - Generation
I can think of several ways to accomplish this (or close to it). * Assign each server a number and prefix/append that number to the unique ID. * initialize each table on each server at a different huge number so they don't ever collide: ALTER TABLE `students` AUTO_INCREMENT=1000; Other server: ALTER TABLE `students` AUTO_INCREMENT=2000; * don't re-invent the wheel and just use UUID() * make the primary key a combination key of a regular auto-increment and NOW() or RAND() or some other unique column of the table itself or something like IP number of the server, etc. * setup a trigger to alter the primary key accordingly prior to insert. Maybe one server is even numbers and the other is odd numbers, or use MOD() or other math to have a pool of servers. http://stackoverflow.com/questions/5416548/mysql-two-column-primary-key-with -auto-increment > -Original Message- > From: Vikram A [mailto:vikkiatb...@yahoo.in] > Sent: Wednesday, July 20, 2011 11:18 PM > To: MY SQL Mailing list > Subject: Next Unique Number - Generation > > Hi there, > > I need a technical help fro you, > I have developed a software for college & school. Here we have concept > called register number/admission number. These are two unique umber for each > student. My application resides Client/server model. > These numbers will be generated (some defined format) to each student when > they are admitted at first time. This admission process is taken place at > different nodes at a time. > In this scenario, I am facing difficulty that, the same number is generated > at time in two machines. (Logic is newest number will be displayed in the > node before admission). > > How can I stop this logical issue? > Can i have solution for this? > > Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL HA on cloud
On Thu, Jul 21, 2011 at 6:20 AM, Yogesh Kore wrote: > Hi, > > I have cloud setup where MySQL servers are installed. > > Replication is applied in between mysql servers. > > Now I want to implemet HA for MySQL. > Can any one help me how can I achieve MySQL failover? > I looked DRBD, Linux Heartbeat, but I am not able to confirm which should I > go for or is there anything else by which I can achieve my goal? > > Thank You. > > Regards, > Yogesh > Getting automatic failover right is near impossible and it is very easy to destroy your data. I strongly suggest not attempting this project. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL HA on cloud
Hi, I have cloud setup where MySQL servers are installed. Replication is applied in between mysql servers. Now I want to implemet HA for MySQL. Can any one help me how can I achieve MySQL failover? I looked DRBD, Linux Heartbeat, but I am not able to confirm which should I go for or is there anything else by which I can achieve my goal? Thank You. Regards, Yogesh