Re: Uninstall Mysql

2002-04-09 Thread Kathy Reyes

I am using Linux 7.2 OS.
I think reseting the root password fixed it. Because I was no able to log
in.
I'm not really running any queries to the mysql database that why i'm not
sure whats causing this problem.
I also cant figure out why when I type mysql it doesnt doesnt use the
password and I alway have to type mysql -u root -p and then password.

- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:00 AM
Subject: Re: Uninstall Mysql


 Kathy,
 Monday, April 08, 2002, 10:10:04 PM, you wrote:

 KR Can anyone tell me how can I uninstall mysql. I have done it again. I
have
 KR messed up my permission.
 KR I dont know what is is that i'm doing that makes me loose my
previleges.
 KR I keep getting the access denied error

 Before uninstalling MySQL server you can
 1. reset root password, look at:
http://www.mysql.com/doc/R/e/Resetting_permissions.html

 2. re-create grant tables, look at:
http://www.mysql.com/doc/m/y/mysql_install_db.html

 And about the MySQL server uninstallation, tell me, what OS do you use?

 KR Kathy Reyes




 --
 For technical support contracts, goto https://order.mysql.com/
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Uninstall Mysql

2002-04-08 Thread Kathy Reyes

Can anyone tell me how can I uninstall mysql. I have done it again. I have
messed up my permission.
I dont know what is is that i'm doing that makes me loose my previleges.
I keep getting the access denied error



Kathy Reyes
Live Technology  International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-04-01 Thread Kathy Reyes

if I dont have the mysql.sock running in the temp folder how do I start
it???
I tried service mysql start and it did work it give me the same error in the
subject line
- Original Message -
From: andy thomas [EMAIL PROTECTED]
To: colin o [EMAIL PROTECTED]
Cc: Mike Yrabedra [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 2:56 PM
Subject: Re: ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)




 On Tue, 26 Mar 2002, colin o wrote:

  Same thing happens to me,
 
  i just use bin/safe_mysqld --user=root 
  to start to server so that i can use mysql.
  I don't know exactly why it happens though.
  Possibly permissions??

 It is better to run mysqld as a non-root user, such as mysql.

  --- Mike Yrabedra [EMAIL PROTECTED] wrote:
  
   What would cause this error to occur all of a
   sudden?
  
   ERROR 2002: Can't connect to local MySQL server
   through socket
   '/tmp/mysql.sock' (2)

 Is the socket? It should show up in a directory listing of /tmp - if it
 isn't there then mysqld isn't running.

 Andy


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mysql datbase backups

2002-03-22 Thread Kathy Reyes

I am still a new to mysql. What is the syntax for backing up a table and how
do I make it no-lock while doing so. I need the tables to still be able to
be written to. I know that this will make my backup a little unaccurate but
that doesnt really matter...
Kathy Reyes
Live Technology  International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access denied on use mysql;

2002-03-21 Thread Kathy Reyes

I just gave up, everything that I tried did not work. 

I killed mysql and then
started with safe_mysql --skip-grant-tables 
then I was able to connect to mysql without an error. 
But when I tried to 
Grant all on mysql.* to root@localhost identified by password;
it gave me the message Unknown Command.

- Original Message - 
From: alan4100 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 11:07 AM
Subject: Re: Access denied on use mysql;


 mysql
 
 Hello Kathy,
 
 How have you made out with access to mysql?
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access denied on use mysql;

2002-03-21 Thread Kathy Reyes

Now I have a different problem. When I type mysql it gives me the message
Access denied for user: 'root@localhost' (Using password: NO)
how do I get it to use the password. 
When I type mysql -u root -p 
I get in...


- Original Message - 
From: alan4100 [EMAIL PROTECTED]
To: Kathy Reyes [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 2:55 PM
Subject: Re: Access denied on use mysql;


 Kathy
 I see.
 - Original Message - 
 From: Kathy Reyes [EMAIL PROTECTED]
 To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Thursday, March 21, 2002 12:48 PM
 Subject: Re: Access denied on use mysql;
 
 
  I just gave up, everything that I tried did not work. 
  
  I killed mysql and then
  started with safe_mysql --skip-grant-tables 
  then I was able to connect to mysql without an error. 
  But when I tried to 
  Grant all on mysql.* to root@localhost identified by password;
  it gave me the message Unknown Command.
  
  - Original Message - 
  From: alan4100 [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, March 21, 2002 11:07 AM
  Subject: Re: Access denied on use mysql;
  
  
   mysql
   
   Hello Kathy,
   
   How have you made out with access to mysql?
   
   
  
  
 
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access denied on use mysql;

2002-03-20 Thread Kathy Reyes

I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
have lost complete access to 'mysql'  datebase
- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Joel Rees [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 9:30 AM
Subject: Re: Access denied on use mysql;


 Joel,


 I have read the manual related to windows several times. But the problem
 that I was not having is not mentioned in the manual.
 I am not too sure if I am the one who needs root canal like someone
earlier
 claimed. Or the manual needs one.  I dont think the manual is helpful for
 beginners.  Of course, I can say that the manual is not  good. Of course,
 everyone can say it is free. The manual blends UNIX with Windows when they
 should be separate.
 And does not explain at all when mysql -u root -p does not work.

 It seems to work for everyone for the first time. Not me!
 Before getting into nitty and gritty details with you on my problem,
please
 dont bring up hardware limits. I have an excellent computer DELL 4100
 Dimension with well over 256 megs ram..etc..etc.. on windows xp just
 installed few days ago.
 My processor is near  1 giga hertz!

 Who has 64 megs and 100 HRZ? Perhaps for those who work in the museum.

 Your information on  how to grant access to databases for specific users
is
 very good, but I was not able to put it to work. I could not done it as a
 root user. It just wont grant access to me  as a root user.I cannot
type
 mysql -u root -p  OR mysql -u root at all. It will display ACCESS denied.
 Same problems with first and second installation. The second installation
 was not necessary; you said you said waste of time. I am not going to
 disagree on that, either. But the NT server from the first installation
must
 have still been running in the background  without my knowing.   I cannot
 explain how things went wrong with the first installation. But it seemed
 that the first installation transmitted disease to the second.
Everything
 was impossible with both of these installations.

 Until then, I learned how to use WINMYSQLADMIN for adding my username and
 password. MYSQLADMIN did not do any good at that time. Still I was not
 granted access until that traffic light icon thing popped up in the right
 corner. There were 7 of them there. I never saw them before! But I think
it
 was the turning point. After deleting one by one. To make story short...I
 learned how to stop and start server with that traffic light icon. When I
 stopped the server, I then started it with NET START MYSQL..

 Then I was able to type in my user name and password (not root user this
 time), but think root user will be granted access. It appears that
 WINMYSQLADMIN is finally put to work. I was granted access on my user
 name/password.  Everything appears to be working fine.  I think removing
 those 7 traffic lites and STOP Server and then START server somehow fixed
 everthing for me.
 I have been granted access already without doing any configuration. I did
 not have that privilege in the beginning.

 The manual does not explain what I should do if mysql -u root -p does not
 work. And on how to use WINMYSQLADMIN on adding users. And also traffic
 lights. There is a program called MYSQLADMIN for DOS does not cover
examples
 on how to using many different commands.

  I am a very new mySQL newbie. I barely start. I feel very sorry for the
new
 comers to mySQL. But hopefully, these new comers are able to locate
 newsgroups like this. I think the documentation does not need 300 pages.
And
 they should be separate with UNIX and WINDOWS.   And explain what we
should
 do if mysql -u root -p does not work in some pages.

 Right now, it is still not clear what went wrong in the very beginning.

 Anyway, thanks for instructing me to cc the list...Now I see how MYSQL
list
 mailing works.

 - Original Message -
 From: Joel Rees [EMAIL PROTECTED]
 To: alan4100 [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Tuesday, March 19, 2002 11:47 PM
 Subject: Re: Access denied on use mysql;


  alan4100:
 
  If you reply to this, please CC the list.
 
  Keep reading the manual while you try things. From your questions, I am
  wondering if you are not reading the manual, or are just too impatient
and
  are trying things before you read the whole story.
 
  If your processor is faster than 100MHz and has more than 64M RAM, I
  recommend downloading the manual.pdf (Adobe Acrobat), so you can browse
it
  off-line. You'll need Acrobat, of course, but Acrobat is useful for
 reading
  many things, well worth the download time. You can find links to the
  documentation pages at mysql's main web page.
 
  To repeat what others have said, you need to understand how to set
  passwords, how 

Re: Access denied on use mysql;

2002-03-20 Thread Kathy Reyes

I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
have lost complete access to 'mysql'  datebase

- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Liyju Janardhan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 10:26 AM
Subject: Re: Access denied on use mysql;


 Hi Liyju,

 Before answering your note, I need to explain about the using the syntax
for
 mysql -u user -p.

 If I use the format above for mysql -u root -p,
  I can press ENTER after typing mysql -u root -p
 and wait for the password inquiry. I dont need to enter the password (I
dont
 have one, anyway) and then click ENTER
 again to bypass the password inquiry. I  think it is the right way to do
 this if I am a root user. I am not sure if the root user can have a
 password. Does it? It does not sound possible. Perhaps someone has already
 mentioned it.

  I had learned the hard way to skip that inquiry. I doubt it is mentioned
in
 the manual. Nevertheless, I have other problems with the installation,
 anyway.

 I think typing in mysql is the very same with mysql -u root -p.
 The grants are the very same. I hope it does. Does it?

 Your explanation about using the grant commmand for those who dont have
 password.

  mysqlgrant all on mysql.* to root@localhost
  identified by '';



 Your correct! But I was not able to do that earlier because of something
 that went wrong with the installation.  And I had 7 traffic lights in
right
 corner without my knowing. After eliminating them and NET CLOSE  MYSQL and
 then NET START MYSQL. I had done that alone several times before to no
 avail.
 It seems the combination of elimination of 7 traffic lights and NET CLOSE
 MYSQL gave me a good fix. I still dont know what the real problem was. I
 thought all I could do was install.

 By now, I know how to use mysql -u root -p, but I could not see how it
could
 affect the installation in any way. I will be watching Mysql for several
 days.

 It looks like the second installation gave more problems.
 The NT server must have still running from the first installation.
 I thought I had deleted all my Mysql directores and subdirectories and
also
 the NT server; but it may had never deleted the NT server that was still
 running.

 I do really appreciate many people who tried to help me out.

  - Original Message -
 From: Liyju Janardhan [EMAIL PROTECTED]
 To: alan4100 [EMAIL PROTECTED]
 Sent: Wednesday, March 20, 2002 12:30 AM
 Subject: Re: Access denied on use mysql;


  Hi Alan,
I am using mysql on linux, so I suggest you
  to send cc to the list, let others help you.
 
  How do you get into mysql? Hope ur doing the
  following.
  $mysql -u root -p
  Since you dont have the password you can use
  $mysql   (remember $ means linux prompt)
  If the above command is successful you get an mysql
  prompt.
  mysqlshow grant for root@localhost;
  since you don't have a password you set the grants
  this way (I am not sure, try it)
  mysqlgrant all on mysql.* to root@localhost
  identified by '';
  Then run mysqladmin outside mysql prompt i.e.
  Linux promptmysqladmin reload
 
  mysqlgrant all on mysql.* to root@loaclhost
  --- alan4100 [EMAIL PROTECTED] wrote:
   Hi,
  
   These errors are produced after using GRANT
   commmand.
   Remember I have no password.
  
  =
  
   mysql grant all on test.* to user@localhost
   identified by password;
   ERROR 1044: Access denied for user: '@localhost' to
   database 'test'
   mysql $mysqladmin reload
   - ;
   ERROR 1064: You have an error in your SQL syntax
   near '$mysqladmin reloa
   ne 1
   mysql show databases;
   +-+
   | Database|
   +-+
   | Meet_a_Geek |
   | database05  |
   | db001   |
   | db002   |
   | mrbs|
   | mysql   |
   | sample_db   |
   | shopcart|
   | test|
   +-+
   9 rows in set (0.00 sec)
  
   mysql
   - Original Message -
   From: Liyju Janardhan [EMAIL PROTECTED]
   To: alan4100 [EMAIL PROTECTED];
   [EMAIL PROTECTED]
   Sent: Tuesday, March 19, 2002 1:37 AM
   Subject: Re: Access denied on use mysql;
  
  
   
--- alan4100 [EMAIL PROTECTED] wrote:
 The problem begins when I type in use mysql;
 Please look at the very left edge with three
 asterisks..*** where I marked. ACCESS denied
 Hope it will be fixed with your help so I can
   mind
 my own chores.

 ==
 C:\mysql\binnet start mysql
 The MySql service is starting.
 The MySql service was started successfully.


 C:\mysql\binmysqladmin ping
 mysqld is alive

 C:\mysql\binmysql
 Welcome to the MySQL 

Fw: Access denied on use mysql;

2002-03-20 Thread Kathy Reyes

I thought I was sending my email to the [EMAIL PROTECTED] but I guess I
wasnt.

Thank you so much for your help Alan,

I cant figure out how I have lost access to 'mysql' (default) database. When
I attempt to use mysql on my Linux machine I get the error message ERROR
1045: Access denied for user: 'root@localhost' (Using password: NO)

How ever I can login using   kreyes and ODBC.

Can anyone please tell me where I can find that my.cnf file I've looked
every where on my linux machine and cant find it.

Thanks all!!!

- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Kathy Reyes [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 11:59 AM
Subject: Re: Access denied on use mysql;


 Kathy,

 First please cc to [EMAIL PROTECTED] . There are others who want to
read
 it. But you said earlier about emails that did not do much of help. I was
 lucky. Perhaps you have to wait for your turn.

 First, I feel I am not ready to solve this problem for you because your
 telneting into the linux machine from Windows 2000 machine.
 I have never tried this.

 I can tell you what I know as a complete beginner. I need to correct my
 saying NET CLOSE SERVER. When it should be NET STOP SERVER.  You need to
 use WINMYSQLADMIN for adding users. There may be other ways, but I only
know
 this way.  But in your case about telneting, I am not sure what your doing
 because I never tried it.  I am not clear about telneting, are your
 accessing data remotely for editing,etc, from your local Mysql server. Or
 vice versa. your transmitting data from your local machine to the remote
 Mysql server.  I think your just accessing remote data.
 Your reply may help.

 I can only describe about my present settings on my pc with mysql. The
 present settings right after the installation of Windows XP,  I did not go
 anything beyond granting privileges to other users like you do.  But it is
 ready to accept my typing input:  USE MYSQL before the database changed in
 computer's reply. At that point, I assume I am granted access to this
MYSQL
 database. Did you type in  USE MYSQL command?

 I dont know why you cannot.  I believe you should cc your emails to
 [EMAIL PROTECTED] Others will help you. I think you have mentioned
 emails, but got no help. Sometimes, patience pays off.
 Good luck. And then enlightment follows.


 - Original Message -
 From: Kathy Reyes [EMAIL PROTECTED]
 To: alan4100 [EMAIL PROTECTED]
 Sent: Wednesday, March 20, 2002 10:54 AM
 Subject: Re: Access denied on use mysql;


  I signed in as follows
 
  mysql -h localhost -u kreyes.
  mysql is installed on a linux machine and I am connecting remotely from
a
  Windows 2000 machine. When I had access as root I was able to add users
 and
  grants. I didnt give myself access to the 'msql' database because I
didnt
  really need it. But up until yesterday I was able to go into mysql by
  telneting into the linux machine and then typing mysql but  now I keep
  getting an error. I'm not sure what you mean by NET CLOSE MYSQL. I am
 kinda
  new to mysql. Please enlighten me
 
  - Original Message -
  From: alan4100 [EMAIL PROTECTED]
  To: Kathy Reyes [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Wednesday, March 20, 2002 10:55 AM
  Subject: Re: Access denied on use mysql;
 
 
   Kathy,
  
   Sounds like mine, but it is fixed. I still dont know what the fix was.
  May
   I ask you how you signed in as Kreyes? Did you add username and
password
   yourself?
  
   Since you are denied access to mysql (default) database, it surely
 sounded
   like mine.   Before I may give you some help, may
   I ask you again how you signed in as Kreyes. Did you use mysqladmin?
How
   long have you been using MySQL? Did you install recently?
  
   It sounds you may need to NET CLOSE MYSQL at DOS PROMPT.
   And then NET START MYSQL again. I am afraid there are still related
  programs
   running in the background. But five it a try.
   Two times at most.  I did that several times over a few days period,
  before
   it worked correctly.  And let me know.
  
  
  
   - Original Message -
   From: Kathy Reyes [EMAIL PROTECTED]
   To: alan4100 [EMAIL PROTECTED]
   Cc: [EMAIL PROTECTED]
   Sent: Wednesday, March 20, 2002 10:11 AM
   Subject: Re: Access denied on use mysql;
  
  
I've tried everything thats in this email and nothing seems to work
 for
   me.
I think my situation is a little different because I had access to
my
database originally but now I cant connect I can sign on as kreyes
but
 I
cant sign on as root. I can even sign in as ODBC. I dont know what
to
  do.
   I
have lost complete access to 'mysql'  datebase
- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Joel Rees [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 9:30 AM
Subject: Re: Access denied on use mysql;
   
   
 Joel,


 I have read the manual related to windows several times. But the
  problem

Re: Date and SQL statement

2002-03-20 Thread Kathy Reyes

select * from accounts where duedate=convert(float,getdate())

- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 12:31 PM
Subject: Date and SQL statement


 I need to do a search where I am looking at the table that has dates and I
 need to look only things that are 30 days or younger.

 Can so one show me a some SQL statements where you use  , ? And the key
 for equal to or less?

 Chuck Payne
 Magi Design


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Cannot access the Database on same Machine

2002-03-20 Thread Kathy Reyes

This might help

 http://ecn.www.ecn.purdue.edu/ECN/Documents/VI/


- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 1:46 PM
Subject: Cannot access the Database on same Machine


 colin,
 Tuesday, March 19, 2002, 11:04:31 PM, you wrote:

 co When i try to access the database which is on my Linux
 co machine i get the following error:
 co ERROR 2002; Can't connect to local MySQL server
 co through socket '/tmp/mysql.sock' (111)

 co There is nothing in this file, although i dont know
 co how to edit it.

 co I have gone through the Manual pages and the lists,
 co all the searches for this type of ERROR, but to no
 co avail.

 Is your MySQL server running?

 Check your privileges on the socket file and on the dir that contains
socket file.
 You can find the description of this error at:
 http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html

 co I have used the database before and have tables in
 co there but for some reason i cannot get in.

 co I don't want to reinstall it as i have tables that i
 co need, I am really stuck so any help will be very much
 co appreciated,
 co Thanks
 co Colin





 --
 For technical support contracts, goto https://order.mysql.com/
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Egor Egorov
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Benchmark

2002-03-19 Thread Kathy Reyes

Hello all its me again
Does any one now of any database benchmarking utility that I can use on
mysql database???


Kathy Reyes
Live Technology  International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MYSQL DATABASE BACKUP

2002-03-19 Thread Kathy Reyes

 I am trying to backup a  table in mysql  without locking my tables it this
posible



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Access denied for user

2002-03-19 Thread Kathy Reyes

I dont know what I have done now but I have locked myself out of mysql. When
I type mysql I get an access violation. At first I thought it might have
been something on my end since I am a remote user. But when I attempt to
enter mysql from linux box. I get the same access violation...
Please someone help me.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Default value support function

2002-03-18 Thread Kathy Reyes

Can I have a default value call a function in a MYSQL table for example

convert(float,getdate())





Kathy Reyes
Live Technology  International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How do I get the time?

2002-03-13 Thread Kathy Reyes

I'm trying time a export process but I cant figure out what the right sql
statement.
I tried using getdate() but it gives me an error.
Any Ideas???
Kathy Reyes
Live Technology  International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php