Re: Table created on script Err

uBois" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 12:56 PM Subject: Re: Table created on script Err > At 12:35 -0500 3/25/02, alan4100 wrote: > >Paul, > > > >You are right. :) > > &

Re: Table created on script Err

Paul, You are right. :) USE alan03 works. USE db_alan03 works. But it created two separate databases. They are not the same. But both works just the same. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTEC

Re: Table created on script Err

Paul, Okay.:) - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]>; "Gerald Clark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 10:56 AM Subject: Re:

Re: Grant all on my mysql.*

Michael, Paul explained. - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Sent: Sunday, March 24, 2002 11:31 PM Subject: Re: Grant all on my mysql.* > > > On Sun, 24 Mar 2002, ala

Re: Grant all on my mysql.*

mysql Paul, Sure you did clear up the whole thing... :) - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 24, 2002 10:31 PM Subject: Re: Grant all on my mysql.

Re: Table created on script Err

mysql Gerald, I will try that; Paul had suggested USE db_name. ..I will try both ways..USE db2 and USE db_xxx .. Will keep you both posted. - Original Message - From: "Gerald Clark" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Cc: <[EMAIL

Re: Grant all on my mysql.*

mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Hope it will be clear later how the password had been stored for the user root. It had to occur before or during the

Re: Grant all on my mysql.*

mysql Michael, You can look at the results after the dash lines. You will notice mysql -u root -h localhost -p does not help at all. I clicked enter to by pass the password;it is acceptable for the root, but look at the results. C:\mysql\bin>mysql -u alan -h localhost -p Enter password:

Re: Table created on script Err

mysql Paul, I was afraid to hear that. It had said about line 2 in the error message. This line #2 looks normal. May I ask you to check this script below, but I am afraid it may be annoying. I will eventually put this on posting. Remember I use Windows XP. I would like to know if there is suc

Re: Grant all on my mysql.*

mysql Michael, This time it went through fine only when I typed in mysql -u alan -h localhost -p It went through fine because I already set up alan for username as well as the pasword for (alan). You said I could only use mysql -u root -p to go through! Perhaps, it will go through even tho

Grant all on my mysql.*

mysql mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password"; Query OK, 0 rows affected (0.00 sec) == At this point the priveleges are granted to root@localhost. mysql> \q Bye I had to type \q to quit and type in the following: But ...

Table created on script Err

After creating a script to create customer table for Meet_a_Geek with an editor and named it 032302.sql. It was saved in the folder called. c:\my download files\. Then at at the mysql\bin> prompt I typed mysql c:\my download files\032302.sql. hoping that this table would be readed and created

Re: Access denied on use mysql;

mysql Brian, Fine...lots of typing.:)

Re: Access denied on use mysql;

mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has been fixed and everything works fine. But I am still having reply

Re: Access denied on use mysql;

mysql kathy, What would happen if you type in mysql -u root -p then type in use mysql

Re: Access denied on use mysql;

mysql Kathy.. Check version of mySQL for me. Did you said after typing mysql -u root -p, you get in fine? Then you type mysql? then access denied... Is this in a sequence? - Original Message - From: "Kathy Reyes" <[EMAIL PROTECTED]> To: "alan4100" &

Re: Access denied on use mysql;

mysql Kathy, I see..

Re: Adding Columns to table

mysql I tried to d/l winmysql from this website: http://www.winmysql.com/page4.html as freeware, but it did not respond. Guess it is busy. Will try again, later. But would you or others suggest me to put it in a separate folder from MySQL folder after the d/l?

Re: Access denied on use mysql;

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

Re: Adding Columns to table

mysql Thanks, Colin for the reference to winmysql..etc. By the way, do you also get this email at your personal email address besides mailing list? It looks like you have to check at this mailing list site, because almost all personal emails have been bounced back. I only reply notes to [EM

Re: Adding Columns to table

mysql Allon, Thanks for the clear and simple example regarding keys. You may notice mysql at the top left corner because without it your letter will bonce back like others (users). eek!

Re: Adding Columns to table

Thanks...Paul It appears impossible to reply your note via Outlook Express because it will return to me like other users. So I am replying this note to [EMAIL PROTECTED] Hope I will hear the solution soon. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]&g

Re: Adding Columns to table

ista (JB-Informática, Lda)" <[EMAIL PROTECTED]> To: "'alan4100'" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 5:41 PM Subject: RE: Adding Columns to table > Hi, > > For a WIndows you can take a look at http://mysqlfront.de it's sample and &

Re: Access denied on use mysql;

== I would like to hear your reply. Then we discuss on it. But my mysql now is working fine. It appears that a script is not needed for installation. I always thought that script is for UNIX. - Original Message - From: "Doug Thompson" <[EMAIL PROTECTED]>

Re: Adding Columns to table

keeping sending one to you and cc to mailing list separately. - Original Message - From: "Tony" <[EMAIL PROTECTED]> To: "'Paul DuBois'" <[EMAIL PROTECTED]>; "alan4100" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, M

Re: Adding Columns to table

mysql - Original Message - From: "Tony" <[EMAIL PROTECTED]> To: "'alan4100'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 2:11 PM Subject: RE: Adding Columns to table Just put a carriage return (e.g. the enter

Adding Columns to table

mysql Ignore this subject, pls..

Adding Columns to table

I am creating a database called Meet_a_Geek at MS DOS prompt. The customer table has about 30 fields..no time counting..but I noticed that I cannot go beyond 9 fields without ending with a semicolon. Also another problem crops up when I tried to recreate the customer table with the remaining fi

Re: Access denied on use mysql;

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

Re: Access denied on use mysql;

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]> Se

Re: Access denied on use mysql;

"mysql" > if that does not work type "mysql -u root " > and press enter > > please let me know.if that resulted in mysql> promt. > > > Cheers > Anis > > > > > > > > > > > > > > > >>> alan

Re: mysql -u root DENIED

- Original Message - From: "Chuck Roberts" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 9:36 AM Subject: RE: mysql -u root DENIED > > > > -Original Message- > > From: alan4100 [mailto:[E

Re: Access denied on use mysql;

ysql 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"

Re: Access denied on use mysql;

f 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]&

mysql -u root DENIED

I just rmdir/s the old mysql and downloaded from Wisconsin mirror site... Then I tried C:\mysql\bin>mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Any idea? I know that I have mysql in NU-SPHERE directory from previous installation about a month ago...

all databases deneid

I typed SELECT SYSTEM_USER() ..The output is ++ | system_user() | ++ | ODBC@localhost | ++ 1 row in set (0.00 sec) I then tried mysql -h localhost -u ODBC Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 t

Access denied on use mysql;

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\bin>net start mysql The MySql service i

Cannot start Mysql on Windowx XP

I just installed MySQL-3.23/mysql-3.23.49-win.zip from www.mysql.com Then opened it. But I still could not run mysql..it looks like it could not find the server. Where is the remote server? Anyway, see below how I was struggling.. C:\mysql>cd\mysql\bin C:\mysql\bin>mysqladmin ping

it cannot inititate downloads

I am trying to download mysql for my windows XP but this url site: http://www.mysql.com/downloads/mysql-3.23.html has been unaccessible for over two weeks. I just could not initiate the download. My provider is Comcast Cable. What is the problem?