Newbie, error using mysql

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
 >> Stay informed about: Newbie, error using mysql 

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" wrote in message

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


  >> 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
 >
 >
 >> Stay informed about: Newbie, error using mysql 

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.
 >
 >


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


  >>
   >>>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
 >> Stay informed about: Newbie, error using mysql 

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." wrote in
message
 > 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.
  >>
  >>


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


   >>>
   >>>>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
 >> Stay informed about: Newbie, error using mysql