Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Newbie, error using mysql

 
   Database Help (Home) -> mySQL RSS
Next:  mySQL GUI's  
Author Message
rguti

External


Since: Feb 19, 2005
Posts: 3



(Msg. 1) Posted: Sat Feb 19, 2005 4:23 pm
Post subject: Newbie, error using mysql
Archived from groups: mailing>database>mysql (more info?)

Hi,

I'm new to MySQL. Yesterday I installed MySQL 5.0.2 alpha for windows. I
installed it on my Windows XP Laptop.

I also installed the "MySql Administrator". Well, I logged in to the
Administrator, went to the "Catalogs" section and created a new schema. Then
I created a new table to this schema and when I went to save the table I got
a Windows error, the one where it asks you if you want to "Send Error
Report" or "Don't Send". After this I get this message:

"A MySQL error was encountered. The message is:

Error while fetching Schema Table Status.
The following error ocurred: Lost connection to MySQL server during query
(2013)"

Then I noticed that my instance is not running. So I start it again but
every time I click on one of the schemas I get the same error.

I can't even add a table. I know this is a beta but I would think that at
least I would be able to create a table.

Do you guys know what might be the problem?

Do you guys know of any support newsgroups/forums for this beta?

Thanks.

 >> Stay informed about: Newbie, error using mysql 
Back to top
Login to vote
Ike

External


Since: Aug 19, 2003
Posts: 49



(Msg. 2) Posted: Sun Feb 20, 2005 12:16 am
Post subject: Re: Newbie, error using mysql [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

version 5.02 appears screwed on Windows - see my post immedialtey before
yours. -Ike

"Randell D." <reply.via.news.group.only.thanks.RemoveThis@fiprojects.moc> wrote in
message news:E_QRd.437877$Xk.104909@pd7tw3no...
 > rguti wrote:
 >
  > > Hi,
  > >
  > > I'm new to MySQL. Yesterday I installed MySQL 5.0.2 alpha for windows. I
  > > installed it on my Windows XP Laptop.
  > >
  > > I also installed the "MySql Administrator". Well, I logged in to the
  > > Administrator, went to the "Catalogs" section and created a new schema.
Then
  > > I created a new table to this schema and when I went to save the table I
got
  > > a Windows error, the one where it asks you if you want to "Send Error
  > > Report" or "Don't Send". After this I get this message:
  > >
  > > "A MySQL error was encountered. The message is:
  > >
  > > Error while fetching Schema Table Status.
  > > The following error ocurred: Lost connection to MySQL server during
query
  > > (2013)"
  > >
  > > Then I noticed that my instance is not running. So I start it again but
  > > every time I click on one of the schemas I get the same error.
  > >
  > > I can't even add a table. I know this is a beta but I would think that
at
  > > least I would be able to create a table.
  > >
  > > Do you guys know what might be the problem?
  > >
  > > Do you guys know of any support newsgroups/forums for this beta?
  > >
  > > Thanks.
  > >
  > >
 >
 > I've got about 12months experience behind me but I'm using v4. If
 > you're new to all this, might I suggest you learn using a stable
 > (non-alpha) version... This might help since support is bound to be far
 > wider from the ng community...
 >
 > I'm wondering - perhaps you've installed MySQL and its an ownership
 > problem (perhaps a non-Administrator owns the MySQL processes and
 > attempting to create the schema directory and files in a directory owned
 > by the administrator).
 >
 > I'l only pulling at straws - but I suggest to learn using a non-alpha
 > version and see how you go.
 >
 > randelld<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Newbie, error using mysql 
Back to top
Login to vote
user2734

External


Since: Jan 06, 2005
Posts: 28



(Msg. 3) Posted: Sun Feb 20, 2005 12:16 am
Post subject: Re: Newbie, error using mysql [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

rguti wrote:

 > Hi,
 >
 > I'm new to MySQL. Yesterday I installed MySQL 5.0.2 alpha for windows. I
 > installed it on my Windows XP Laptop.
 >
 > I also installed the "MySql Administrator". Well, I logged in to the
 > Administrator, went to the "Catalogs" section and created a new schema. Then
 > I created a new table to this schema and when I went to save the table I got
 > a Windows error, the one where it asks you if you want to "Send Error
 > Report" or "Don't Send". After this I get this message:
 >
 > "A MySQL error was encountered. The message is:
 >
 > Error while fetching Schema Table Status.
 > The following error ocurred: Lost connection to MySQL server during query
 > (2013)"
 >
 > Then I noticed that my instance is not running. So I start it again but
 > every time I click on one of the schemas I get the same error.
 >
 > I can't even add a table. I know this is a beta but I would think that at
 > least I would be able to create a table.
 >
 > Do you guys know what might be the problem?
 >
 > Do you guys know of any support newsgroups/forums for this beta?
 >
 > Thanks.
 >
 >

I've got about 12months experience behind me but I'm using v4. If
you're new to all this, might I suggest you learn using a stable
(non-alpha) version... This might help since support is bound to be far
wider from the ng community...

I'm wondering - perhaps you've installed MySQL and its an ownership
problem (perhaps a non-Administrator owns the MySQL processes and
attempting to create the schema directory and files in a directory owned
by the administrator).

I'l only pulling at straws - but I suggest to learn using a non-alpha
version and see how you go.

randelld<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Newbie, error using mysql 
Back to top
Login to vote
rguti

External


Since: Feb 19, 2005
Posts: 3



(Msg. 4) Posted: Sun Feb 20, 2005 2:01 pm
Post subject: Re: Newbie, error using mysql [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks guys,

I wanted to test out the stored procedures but I think I will just have to
go to 4 just so I can start using it. I'm gonna see about the ownership
thing, I log in using the 'root' user but maybe the ownership thing that you
mention has anything to do with it.

Thanks again.


"Ike" <rxv.TakeThisOut@hotmail.com> wrote in message
news:CtRRd.1100$MY6.628@newsread1.news.pas.earthlink.net...
 > version 5.02 appears screwed on Windows - see my post immedialtey before
 > yours. -Ike
 >
 > "Randell D." <reply.via.news.group.only.thanks.TakeThisOut@fiprojects.moc> wrote in
 > message news:E_QRd.437877$Xk.104909@pd7tw3no...
  >> rguti wrote:
  >>
   >> > Hi,
   >> >
   >> > I'm new to MySQL. Yesterday I installed MySQL 5.0.2 alpha for windows.
   >> > I
   >> > installed it on my Windows XP Laptop.
   >> >
   >> > I also installed the "MySql Administrator". Well, I logged in to the
   >> > Administrator, went to the "Catalogs" section and created a new schema.
 > Then
   >> > I created a new table to this schema and when I went to save the table
   >> > I
 > got
   >> > a Windows error, the one where it asks you if you want to "Send Error
   >> > Report" or "Don't Send". After this I get this message:
   >> >
   >> > "A MySQL error was encountered. The message is:
   >> >
   >> > Error while fetching Schema Table Status.
   >> > The following error ocurred: Lost connection to MySQL server during
 > query
   >> > (2013)"
   >> >
   >> > Then I noticed that my instance is not running. So I start it again but
   >> > every time I click on one of the schemas I get the same error.
   >> >
   >> > I can't even add a table. I know this is a beta but I would think that
 > at
   >> > least I would be able to create a table.
   >> >
   >> > Do you guys know what might be the problem?
   >> >
   >> > Do you guys know of any support newsgroups/forums for this beta?
   >> >
   >> > Thanks.
   >> >
   >> >
  >>
  >> I've got about 12months experience behind me but I'm using v4. If
  >> you're new to all this, might I suggest you learn using a stable
  >> (non-alpha) version... This might help since support is bound to be far
  >> wider from the ng community...
  >>
  >> I'm wondering - perhaps you've installed MySQL and its an ownership
  >> problem (perhaps a non-Administrator owns the MySQL processes and
  >> attempting to create the schema directory and files in a directory owned
  >> by the administrator).
  >>
  >> I'l only pulling at straws - but I suggest to learn using a non-alpha
  >> version and see how you go.
  >>
  >> randelld
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Newbie, error using mysql 
Back to top
Login to vote
user2734

External


Since: Jan 06, 2005
Posts: 28



(Msg. 5) Posted: Mon Feb 21, 2005 4:40 pm
Post subject: Re: Newbie, error using mysql [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

rguti wrote:
 > Thanks guys,
 >
 > I wanted to test out the stored procedures but I think I will just have to
 > go to 4 just so I can start using it. I'm gonna see about the ownership
 > thing, I log in using the 'root' user but maybe the ownership thing that you
 > mention has anything to do with it.
 >
 > Thanks again.
 >
 >
 > "Ike" <rxv.TakeThisOut@hotmail.com> wrote in message
 > news:CtRRd.1100$MY6.628@newsread1.news.pas.earthlink.net...
 >
  >>version 5.02 appears screwed on Windows - see my post immedialtey before
  >>yours. -Ike
  >>
  >>"Randell D." <reply.via.news.group.only.thanks.TakeThisOut@fiprojects.moc> wrote in
  >>message news:E_QRd.437877$Xk.104909@pd7tw3no...
  >>
   >>>rguti wrote:
   >>>
   >>>
   >>>>Hi,
   >>>>
   >>>>I'm new to MySQL. Yesterday I installed MySQL 5.0.2 alpha for windows.
   >>>>I
   >>>>installed it on my Windows XP Laptop.
   >>>>
   >>>>I also installed the "MySql Administrator". Well, I logged in to the
   >>>>Administrator, went to the "Catalogs" section and created a new schema.
  >>
  >>Then
  >>
   >>>>I created a new table to this schema and when I went to save the table
   >>>>I
  >>
  >>got
  >>
   >>>>a Windows error, the one where it asks you if you want to "Send Error
   >>>>Report" or "Don't Send". After this I get this message:
   >>>>
   >>>>"A MySQL error was encountered. The message is:
   >>>>
   >>>>Error while fetching Schema Table Status.
   >>>>The following error ocurred: Lost connection to MySQL server during
  >>
  >>query
  >>
   >>>>(2013)"
   >>>>
   >>>>Then I noticed that my instance is not running. So I start it again but
   >>>>every time I click on one of the schemas I get the same error.
   >>>>
   >>>>I can't even add a table. I know this is a beta but I would think that
  >>
  >>at
  >>
   >>>>least I would be able to create a table.
   >>>>
   >>>>Do you guys know what might be the problem?
   >>>>
   >>>>Do you guys know of any support newsgroups/forums for this beta?
   >>>>
   >>>>Thanks.
   >>>>
   >>>>
   >>>
   >>>I've got about 12months experience behind me but I'm using v4. If
   >>>you're new to all this, might I suggest you learn using a stable
   >>>(non-alpha) version... This might help since support is bound to be far
   >>>wider from the ng community...
   >>>
   >>>I'm wondering - perhaps you've installed MySQL and its an ownership
   >>>problem (perhaps a non-Administrator owns the MySQL processes and
   >>>attempting to create the schema directory and files in a directory owned
   >>>by the administrator).
   >>>
   >>>I'l only pulling at straws - but I suggest to learn using a non-alpha
   >>>version and see how you go.
   >>>
   >>>randelld
  >>
  >>
 >
 >

FYI MySQL has its own owner/group access method (you use it when you log
in to the server as user root, as you mention above) however I was
implying the problems might well be Windoze XP permissions... There are
two sorts of users in a Windoze XP platform - Administrator and Limited
- it could well be that as a Limited user you might well have been
trying to access or create a directory owned by an Administrator... Its
just a guess, however as someone else has mentioned in this ng, v5 alpha
on XP doesn't seems buggy...

I think better stick with v4 since its stable and alot of folk have
experience with it on mixed platforms. I come from a LAMP (Linux,
Apache, MySQL and PHP) background however I develope using WAMP
(everything on Windoze XP) and I use v4.1.8 and it works like a charm
(though it never gets under pressure since its only personal use on my
own laptop).

Hope something above helps... best of luck and don't give up...

randelld<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Newbie, error using mysql 
Back to top
Login to vote
rguti

External


Since: Feb 19, 2005
Posts: 3



(Msg. 6) Posted: Mon Feb 21, 2005 11:40 pm
Post subject: Re: Newbie, error using mysql [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks for the help,

I was logging in as a user with Administrator permissions. I'm just gonna
wait until 5 is stable and use 4. Thanks again for your help.


"Randell D." <reply.via.news.group.only.thanks DeleteThis @fiprojects.moc> wrote in
message news:8LrSd.457410$8l.206244@pd7tw1no...
 > rguti wrote:
  >> Thanks guys,
  >>
  >> I wanted to test out the stored procedures but I think I will just have
  >> to go to 4 just so I can start using it. I'm gonna see about the
  >> ownership thing, I log in using the 'root' user but maybe the ownership
  >> thing that you mention has anything to do with it.
  >>
  >> Thanks again.
  >>
  >>
  >> "Ike" <rxv DeleteThis @hotmail.com> wrote in message
  >> news:CtRRd.1100$MY6.628@newsread1.news.pas.earthlink.net...
  >>
   >>>version 5.02 appears screwed on Windows - see my post immedialtey before
   >>>yours. -Ike
   >>>
   >>>"Randell D." <reply.via.news.group.only.thanks DeleteThis @fiprojects.moc> wrote in
   >>>message news:E_QRd.437877$Xk.104909@pd7tw3no...
   >>>
   >>>>rguti wrote:
   >>>>
   >>>>
   >>>>>Hi,
   >>>>>
   >>>>>I'm new to MySQL. Yesterday I installed MySQL 5.0.2 alpha for windows.
   >>>>>I
   >>>>>installed it on my Windows XP Laptop.
   >>>>>
   >>>>>I also installed the "MySql Administrator". Well, I logged in to the
   >>>>>Administrator, went to the "Catalogs" section and created a new schema.
   >>>
   >>>Then
   >>>
   >>>>>I created a new table to this schema and when I went to save the table
   >>>>>I
   >>>
   >>>got
   >>>
   >>>>>a Windows error, the one where it asks you if you want to "Send Error
   >>>>>Report" or "Don't Send". After this I get this message:
   >>>>>
   >>>>>"A MySQL error was encountered. The message is:
   >>>>>
   >>>>>Error while fetching Schema Table Status.
   >>>>>The following error ocurred: Lost connection to MySQL server during
   >>>
   >>>query
   >>>
   >>>>>(2013)"
   >>>>>
   >>>>>Then I noticed that my instance is not running. So I start it again but
   >>>>>every time I click on one of the schemas I get the same error.
   >>>>>
   >>>>>I can't even add a table. I know this is a beta but I would think that
   >>>
   >>>at
   >>>
   >>>>>least I would be able to create a table.
   >>>>>
   >>>>>Do you guys know what might be the problem?
   >>>>>
   >>>>>Do you guys know of any support newsgroups/forums for this beta?
   >>>>>
   >>>>>Thanks.
   >>>>>
   >>>>>
   >>>>
   >>>>I've got about 12months experience behind me but I'm using v4. If
   >>>>you're new to all this, might I suggest you learn using a stable
   >>>>(non-alpha) version... This might help since support is bound to be far
   >>>>wider from the ng community...
   >>>>
   >>>>I'm wondering - perhaps you've installed MySQL and its an ownership
   >>>>problem (perhaps a non-Administrator owns the MySQL processes and
   >>>>attempting to create the schema directory and files in a directory owned
   >>>>by the administrator).
   >>>>
   >>>>I'l only pulling at straws - but I suggest to learn using a non-alpha
   >>>>version and see how you go.
   >>>>
   >>>>randelld
   >>>
   >>>
  >>
  >>
 >
 > FYI MySQL has its own owner/group access method (you use it when you log
 > in to the server as user root, as you mention above) however I was
 > implying the problems might well be Windoze XP permissions... There are
 > two sorts of users in a Windoze XP platform - Administrator and Limited -
 > it could well be that as a Limited user you might well have been trying to
 > access or create a directory owned by an Administrator... Its just a
 > guess, however as someone else has mentioned in this ng, v5 alpha on XP
 > doesn't seems buggy...
 >
 > I think better stick with v4 since its stable and alot of folk have
 > experience with it on mixed platforms. I come from a LAMP (Linux, Apache,
 > MySQL and PHP) background however I develope using WAMP (everything on
 > Windoze XP) and I use v4.1.8 and it works like a charm (though it never
 > gets under pressure since its only personal use on my own laptop).
 >
 > Hope something above helps... best of luck and don't give up...
 >
 > randelld<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Newbie, error using mysql 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]