Autostart not working for me in 5.5.8 version

Hi, Please help to set up the autostart of mysql when the Linux server=
starts. It is not working for me after installing to version 5.5.8. I=
have been using different versions of mysql for quite some time with diffe=
rent servers, Fedora versions. All these are working for autostart. But for=
this 5.5.8 I tried on two servers and both are not working for autostart. =
Please help. The following are my details:=3D- =0AIns=
talled on Fedora 12 Linux=0APreviously mysql 5.1.48 is working and autorest=
art is also working. Now installed 5.5.8=0AUsing manual starting is wo=
rking=0A/usr/local/mysql/bin/mysqld_safe & But the auto start is not w=
orking.=0AI have done this=0A$ cp /usr/local/mysql/bin/support-files/mysql.=
server /etc/init.d/mysql=0A$ chmod +x /etc/init.d/mysql=0A$ ln â€=93s /=
etc/init.d/mysql /etc/rc3.d/S99mysql=0A$ ln â€=93s /etc/init.d/mysql /e=
tc/rc5.d/S99mysql=0A$ ln â€=93s /etc/init.d/mysql /etc/rc0.d/K01mysql=
=0Athanks and rgds,

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Autostart not working for me in 5.5.8 version

Hi, I will answer my own question. I have to add a line in (/etc=
/my.cnf) as follows:- basedir=3D/usr/local/mysql I have installed=
mysql in /usr/local/mysql. But the same was done in previous versions and =
I do not need to add this. Anyway, now that it is working. rgds,=
--- On Thu, 12/16/10, Yangontha Maung =
wrote: > From: Yangontha Maung =0A> Subject:=
Autostart not working for me in 5.5.8 version=0A> To: mysql@lists.mysql.co=
m=0A> Date: Thursday, December 16, 2010, 11:14 AM=0A> Hi,=0A> =0A> Please h=
elp to set up the autostart of mysql when the Linux=0A> server starts. It i=
s not working for me after installing to=0A> version 5.5.8.=0A> =0A> I have=
been using different versions of mysql for quite=0A> some time with differ=
ent servers, Fedora versions. All these=0A> are working for autostart. But =
for this 5.5.8 I tried on two=0A> servers and both are not working for auto=
start. =0A> =0A> Please help.=0A> =0A> The following are my details:=3D-=0A=
> =0A> =0A> =0A> =0A> Installed on Fedora 12 Linux=0A> Previously mysql 5.1=
..48 is working and autorestart is also=0A> working.=0A> =0A> Now installed =
5.5.8=0A> Using manual starting is working=0A> /usr/local/mysql/bin/mysqld_=
safe &=0A> =0A> But the auto start is not working.=0A> I have done this=0A>=
$ cp /usr/local/mysql/bin/support-files/mysql.server=0A> /etc/init.d/mysql=
=0A> $ chmod +x /etc/init.d/mysql=0A> $ ln â€=93s /etc/init.d/mysql /et=
c/rc3.d/S99mysql=0A> $ ln â€=93s /etc/init.d/mysql /etc/rc5.d/S99mysql=
=0A> $ ln â€=93s /etc/init.d/mysql /etc/rc0.d/K01mysql=0A> =0A> =0A> th=
anks and rgds,=0A> =0A> =0A> =0A> =0A> =0A> =0A> =0A> --=0A> MySQL General =
Mailing List=0A> For list archives: http://lists.mysql.com/mysql=0A> To uns=
ubscribe:    http://lists.mysql.com/mysql?unsub=3Dyangontha55sg@y=
ahoo.com=0A> =0A> =0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Unable to add users with MySQL 5.5.8 under Windows

--------------050109030301000601090903
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I just downloaded MySQL 5.5.8 (Win64 version) today and installed it on
my dev machine. Previously I had MySQL 5.1.51 installed - as I've
always felt it was better to uninstall the old before installing the new
with Windows, I uninstalled 5.1.51 by doing the following:
- As Administrator, I ran DOS prompt and entered NET STOP MYSQL
- Ran MySQL Instance Configuration Wizard to remove the current instance
- Uninstalled MySQL Server 5.1.51 from Control Panel
- Went through my Users, ProgramData, and Program Files folders to
delete any references to MySQL.
- Reboot computer

I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
MySQL was installed, I downloaded and installed the current version of
Workbench (5.2.31a). When I run Workbench, I see that the MySQL server
is indeed running - I'll also mention that this is my first time using
Workbench, until now I had been using the older MySQL Administrator GUI,
however it stopped working with 5.5.8. So, back in Workbench, I goto
Manage Security under the Server Administration heading, choosing the
default Local instance: MySQL server to connect to. Next I click
Accounts and finally Add Account at the bottom of this screen. Under
Details for Account newuser@% I add in the user name I want, type the
password twice, I've tried leaving Limit Connectivity to Hosts Matching
as % and localhost.

Once I'm finished adding the user, I click Apply - however I'm presented
with the following error message:

/Unhandled exception: Error adding account accountName@%:/

I've tried adding a user in MySQL Administrator, as I am more familiar
with it. It provides a different error:

/Error while storing the user information. The user might have been
deleted. Please refersh the user list./

A command prompt pop-up appears with this error stating the following:

/** Message: save user: error adding new user entry

/I've googled the above error messages and found that either bug reports
with similar wording were either abandoned, or supposed to be fixed
already. Any thoughts, or should I go back to 5.1.51 and wait for the
next point release of the 5.5 line?

TIA,
-Tim

--------------050109030301000601090903--

Re: Unable to add users with MySQL 5.5.8 under Windows

--------------060501000408030700020301
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 12/16/2010 3:42 AM, Tim Thorburn wrote:
> I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
> installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
> MySQL was installed, I downloaded and installed the current version of
> Workbench (5.2.31a). When I run Workbench, I see that the MySQL
> server is indeed running - I'll also mention that this is my first
> time using Workbench, until now I had been using the older MySQL
> Administrator GUI, however it stopped working with 5.5.8. So, back in
> Workbench, I goto Manage Security under the Server Administration
> heading, choosing the default Local instance: MySQL server to connect
> to. Next I click Accounts and finally Add Account at the bottom of
> this screen. Under Details for Account newuser@% I add in the user
> name I want, type the password twice, I've tried leaving Limit
> Connectivity to Hosts Matching as % and localhost.
>
> Once I'm finished adding the user, I click Apply - however I'm
> presented with the following error message:
>
> /Unhandled exception: Error adding account accountName@%:/
>
> I've tried adding a user in MySQL Administrator, as I am more familiar
> with it. It provides a different error:
>
> /Error while storing the user information. The user might have been
> deleted. Please refersh the user list./
>
> A command prompt pop-up appears with this error stating the following:
>
> /** Message: save user: error adding new user entry

To add, I was able to successfully add a user to MySQL 5.5.8 with
phpMyAdmin - would this point to a bug in the GUI tools?

Thanks again

--------------060501000408030700020301--

Re: Autostart not working for me in 5.5.8 version

--00163630f98b86c25b049786c146
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

You are right. In previous version init script have a default value, now is
empty.

mysql 5.1..53 - basedir=3D/usr/local/mysql

mysql-5.5.8 - basedir=3D.

Cheers.

On Thu, Dec 16, 2010 at 12:42 AM, Yangontha Maung
wrote:

> Hi,
>
> I will answer my own question.
>
> I have to add a line in (/etc/my.cnf) as follows:-
>
> basedir=3D/usr/local/mysql
>
> I have installed mysql in /usr/local/mysql. But the same was done in
> previous versions and I do not need to add this.
>
> Anyway, now that it is working.
>
> rgds,
>
>
>
> --- On Thu, 12/16/10, Yangontha Maung wrote:
>
> > From: Yangontha Maung
> > Subject: Autostart not working for me in 5.5.8 version
> > To: mysql@lists.mysql.com
> > Date: Thursday, December 16, 2010, 11:14 AM
> > Hi,
> >
> > Please help to set up the autostart of mysql when the Linux
> > server starts. It is not working for me after installing to
> > version 5.5.8.
> >
> > I have been using different versions of mysql for quite
> > some time with different servers, Fedora versions. All these
> > are working for autostart. But for this 5.5.8 I tried on two
> > servers and both are not working for autostart.
> >
> > Please help.
> >
> > The following are my details:=3D-
> >
> >
> >
> >
> > Installed on Fedora 12 Linux
> > Previously mysql 5.1.48 is working and autorestart is also
> > working.
> >
> > Now installed 5.5.8
> > Using manual starting is working
> > /usr/local/mysql/bin/mysqld_safe &
> >
> > But the auto start is not working.
> > I have done this
> > $ cp /usr/local/mysql/bin/support-files/mysql.server
> > /etc/init.d/mysql
> > $ chmod +x /etc/init.d/mysql
> > $ ln =96s /etc/init.d/mysql /etc/rc3.d/S99mysql
> > $ ln =96s /etc/init.d/mysql /etc/rc5.d/S99mysql
> > $ ln =96s /etc/init.d/mysql /etc/rc0.d/K01mysql
> >
> >
> > thanks and rgds,
> >
> >
> >
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Dyangontha55sg@yahoo.com
> >
> >
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dalejandrob@olx.co=
m
>
>


--=20


Infrastructure Team

OLX Inc.

Buenos Aires - Argentina
Phone : 54.11.4775.6696
Mobile : 54.911.50436059
Email: alejandrob@olx.com

--00163630f98b86c25b049786c146--

Re: Unable to add users with MySQL 5.5.8 under Windows

On 12/16/2010 03:53, Tim Thorburn wrote:
> On 12/16/2010 3:42 AM, Tim Thorburn wrote:
>> I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
>> installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
>> MySQL was installed, I downloaded and installed the current version of
>> Workbench (5.2.31a). When I run Workbench, I see that the MySQL server
>> is indeed running - I'll also mention that this is my first time using
>> Workbench, until now I had been using the older MySQL Administrator
>> GUI, however it stopped working with 5.5.8. So, back in Workbench, I
>> goto Manage Security under the Server Administration heading, choosing
>> the default Local instance: MySQL server to connect to. Next I click
>> Accounts and finally Add Account at the bottom of this screen. Under
>> Details for Account newuser@% I add in the user name I want, type the
>> password twice, I've tried leaving Limit Connectivity to Hosts
>> Matching as % and localhost.
>>
>> Once I'm finished adding the user, I click Apply - however I'm
>> presented with the following error message:
>>
>> /Unhandled exception: Error adding account accountName@%:/
>>
>> I've tried adding a user in MySQL Administrator, as I am more familiar
>> with it. It provides a different error:
>>
>> /Error while storing the user information. The user might have been
>> deleted. Please refersh the user list./
>>
>> A command prompt pop-up appears with this error stating the following:
>>
>> /** Message: save user: error adding new user entry
>
> To add, I was able to successfully add a user to MySQL 5.5.8 with
> phpMyAdmin - would this point to a bug in the GUI tools?
>
> Thanks again
>

Yes, that would be a problem localized to the GUI tool. Please visit
http://bugs.mysql.com/
and either open a new bug describing your problems or add your details
to any existing bugs that may already match your description. The team
that manages that tool may ask for additional information so please do
respond or we will close the bug as "No Feedback".

Warmly,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Autostart not working for me in 5.5.8 version

On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote:
> You are right. In previous version init script have a default value, now is
> empty.
>
> mysql 5.1..53 - basedir=/usr/local/mysql
>
> mysql-5.5.8 - basedir=.
>


/me ponders at who the IDIOT is that decided that cmake is the way of
mysql now.
I mean WTF...

--prefix=/usr -DCMAKE_INSTALL_PREFIX=/usr

--sharedstatedir=/usr/share/mysql -DINSTALL_SHAREDIR=share


etc etc etc etc etc

*loooooong fucking sigh*

/me sticks with 5.1





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Autostart not working for me in 5.5.8 version

Hi Noel, all!


Noel Butler wrote:
> On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote:
>> You are right. In previous version init script have a default value, n=
ow is
>> empty.
>>
>> mysql 5.1..53 - basedir=3D/usr/local/mysql
>>
>> mysql-5.5.8 - basedir=3D.
>>
>=20
>=20
> /me ponders at who the IDIOT is that decided that cmake is the way of
> mysql now.
> I mean WTF...

It was the ones who realized that two different build mechanisms
(autotools for Unix, cmake for Windows) will always cause divergence,
when one is maintained with a change and the other isn't.

Being database people, we know the importance of consistency ;)

>=20
> [[...]]
>=20
> /me sticks with 5.1

Do as you like, but realize that 5.1 won't see major development in the
future and will be put on "extended support only" in due time.

So if anybody encounters differences between 5.1 and 5.5 in such
settings which aren't documented (=3D by intention, or unavoidable),
please file bugs to get them fixed.


Jörg

--=20
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Autostart not working for me in 5.5.8 version

--=-NEB0I4Vip7FbNw7p5n7l
Content-Type: multipart/related; type="multipart/alternative";
boundary="=-Kzt/y1K17qEBugiBJqjh"


--=-Kzt/y1K17qEBugiBJqjh
Content-Type: multipart/alternative; boundary="=-Qk1QjPdtCJ+hlvT7Faj6"


--=-Qk1QjPdtCJ+hlvT7Faj6
Content-Type: text/plain; charset="ISO-8859-15"
Content-Transfer-Encoding: quoted-printable

Hi Joerg,

On Mon, 2010-12-20 at 18:59 +0100, Joerg Bruehe wrote:

> Hi Noel, all!
>=20
>=20
> Noel Butler wrote:
> > On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote:
> >> You are right. In previous version init script have a default value, n=
ow is
> >> empty.
> >>
> >> mysql 5.1..53 - basedir=3D/usr/local/mysql
> >>
> >> mysql-5.5.8 - basedir=3D.
> >>
> >=20
> >=20
> > /me ponders at who the IDIOT is that decided that cmake is the way of
> > mysql now.
> > I mean WTF...
>=20
> It was the ones who realized that two different build mechanisms
> (autotools for Unix, cmake for Windows) will always cause divergence,
> when one is maintained with a change and the other isn't.
>=20
> Being database people, we know the importance of consistency ;)
>=20


I can tell its done by windowsy people, it has pretty colours :)
seriously though , it's almost as bad as trying to figure out what to
give postifx hehe
And in the real world, many sysadmins have to build the database servers
for the database admins, I've made my opinion known about cmake so I'll
leave my cursing at that.



> >=20
> > /me sticks with 5.1
>=20
> Do as you like, but realize that 5.1 won't see major development in the
> future and will be put on "extended support only" in due time.
>=20


For what we use it for, it's likely fine, (user auth/radius/web/mail etc
etc etc) nothing complex.


> So if anybody encounters differences between 5.1 and 5.5 in such
> settings which aren't documented (=3D by intention, or unavoidable),
> please file bugs to get them fixed.
>=20


Well, the documentation could be a little more in depth, if you remove
method A, and if method B is completely compatible, then there must be
detailed information, it is not very good for time management to spend
hours looking over the website, yes forge.mysql.com has a handy
reference, but the bit about replacing, for instance plugins=3Dmax, it is
not clear what we need to include, we know what is default, and some
examples of to add given the example given, but no reference to the max
server, without time consuming research to see what plugins=3Dmax
includes, compare, then find equivalent DINSTALL_blah=3D1's to add, I
think it is a backwards step, and you're likely to see more cussing as
more go to upgrade.

Nice thing though, my original my.cnf didnt cause it to bail out upon
restart, however I only installed it on one very light use server.
want to lay with it a bit before it goes on anything too serious.

Cheers


--=-Qk1QjPdtCJ+hlvT7Faj6
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable








Hi Joerg,



On Mon, 2010-12-20 at 18:59 +0100, Joerg Bruehe wrote:

Hi Noel, all!





Noel Butler wrote:

> On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote:

>> You are right. In previous version init script have a default valu=

e, now is

>> empty.

>>

>> mysql 5.1..53   -   basedir=3D/usr/local/mysql

>>

>> mysql-5.5.8  -   basedir=3D.

>>

>=20

>=20

> /me ponders at who the IDIOT is that decided that cmake is the way of

> mysql now.

>  I mean WTF...



It was the ones who realized that two different build mechanisms

(autotools for Unix, cmake for Windows) will always cause divergence,

when one is maintained with a change and the other isn't.



Being database people, we know the importance of consistency  ;)

>=20

> /me sticks with 5.1



Do as you like, but realize that 5.1 won't see major development in the

future and will be put on "extended support only" in due time.

So if anybody encounters differences between 5.1 and 5.5 in such

settings which aren't documented (=3D by intention, or unavoidable),

please file bugs to get them fixed.