Re: adding columns to a large table
At 12:53 PM 9/25/2006, Helen M Hudson wrote: I have a table with about 3million rows and I'm having trouble altering it to add 4 more columns. I'm using the MySQL Administrator and I've left it more than 24hours and its still not finished. I was going to try using a login to the console next, but is there a better way? Any advice much appreciated! Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi Helen, I would like to know what type of engine your using in mysql? Is it mysisam or innodb? thank you, Ehrwin C. Mina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hello how to connect MySQL with Visual Foxpro
Hi Venu, I would like to know the OS your using (for mysql server), BTW if your using window. Try installing the myodbc and configure it so that vfoxpro can communicate with it. check this site: http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP At 06:28 PM 5/22/2006, VenuGopal Papasani wrote: Hi all, I have got a database in mysql and i need to use the gis and that was in VFOXPRO.I need to display my data which is mysql on the map which database is in VFoXPRO.Is there any way to have communication betweeen these two DBs. Thanks and regards, venu. Ehrwin C. Mina Chikka Phils. Inc. A CMMI LEVEL 5, AND A ISO 9001:2000; ISO 15000:2002; ISO 17799:2002 CERTIFIED COMPANY This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Password for Root
At 02:57 PM 4/10/2006, Kosala Atapattu wrote: Hi people, I have a small problem. I forgot the password for user root in my personal MySQL instance. I'm a Linux user and running Debian Sarge on my computer. I have few other DBs which I created and which I have access to (still I remember the passwords) but are not having access to MySQL database. Is there any way to recover from this situation. If I reinitialize the DB (somehow) how can I port my existing information back in to the initialized DB (without exporting and importing). Any Debian friends who can help me. Cheers, Kosala -- HI Kosala, You can try to use this documentation. Thanks, Ehrwin MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] MySQL: changing forgotten root password (mysqld) Applicable to: Red Hat Linux Systems Updated: Mar 18, 2004 This Sheet describes the procedure how to change the root password of MySQL server. * Stop MySQL server if its running. * # service mysqld stop * Check that MySQL daemon has stopped * # ps -jef | grep mysqld * Start MySQL as root * # su - * # /usr/libexec/mysqld -Sg --user=root * Go back into MySQL with the client: * # mysql * mysql use mysql * Now change the MySQL root password * mysql UPDATE user SET password=password(newpassword) WHERE user=root; mysql flush privileges; mysql exit; * Stop MySQL server. * # killall mysqld * Verify that MySQL daemon is not running * # ps -jef | grep mysqld * Start MySQL the normal way, and all is good. For Red Hat this is: * # service mysqld start * Verify if MySQL daemon is running * # ps -jef | grep mysqld That's it. Jett Tayer and Ehrwin Mina Jett Tayer and Ehrwin Mina
Re: ~BCP for mysql~
Hi, You can try to use the command select into outfile. thanks, ehrwin At 03:29 PM 3/22/2006, Mohammed Abdul Azeem wrote: Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is there any other tool which can do the same operation. I need to perform a bcp out from Mysql and then bcp in to Sybase. Please help me out regarding the same. Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Ehrwin C. Mina Chikka Phils. Inc. A CMMI LEVEL 5, AND A ISO 9001:2000; ISO 15000:2002; ISO 17799:2002 CERTIFIED COMPANY This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: timestamp
Ryan,
Try to use this date functions.
* DATE_ADD(date,INTERVAL expr type) , DATE_SUB(date,INTERVAL expr type)
These functions perform date arithmetic. date is a DATETIME or DATE value
specifying the starting date. expr is an expression specifying the interval
value to be added or subtracted from the starting date. expr is a string;
it may start with a '-' for negative intervals. type is a keyword
indicating how the expression should be interpreted.
The INTERVAL keyword and the type specifier are not case sensitive.
The following table shows how the type and expr arguments are related:
type Value Expected expr Format MICROSECOND MICROSECONDS SECOND SECONDS
MINUTE MINUTES HOUR HOURS DAY DAYS WEEK WEEKS MONTH MONTHS QUARTER QUARTERS
YEAR YEARS SECOND_MICROSECOND 'SECONDS.MICROSECONDS' MINUTE_MICROSECOND
'MINUTES.MICROSECONDS' MINUTE_SECOND 'MINUTES:SECONDS' HOUR_MICROSECOND
'HOURS.MICROSECONDS' HOUR_SECOND 'HOURS:MINUTES:SECONDS' HOUR_MINUTE
'HOURS:MINUTES' DAY_MICROSECOND 'DAYS.MICROSECONDS' DAY_SECOND 'DAYS
HOURS:MINUTES:SECONDS' DAY_MINUTE 'DAYS HOURS:MINUTES' DAY_HOUR 'DAYS
HOURS' YEAR_MONTH 'YEARS-MONTHS'
The type values DAY_MICROSECOND, HOUR_MICROSECOND, MINUTE_MICROSECOND,
SECOND_MICROSECOND, and MICROSECOND are allowed as of MySQL 4.1.1. The
values QUARTER and WEEK are allowed as of MySQL 5.0.0.
MySQL allows any punctuation delimiter in the expr format. Those shown
in the table are the suggested delimiters. If the date argument is a DATE
value and your calculations involve only YEAR, MONTH, and DAY parts (that
is, no time parts), the result is a DATE value. Otherwise, the result is a
DATETIME value.
As of MySQL 3.23, INTERVAL expr type is allowed on either side of the +
operator if the expression on the other side is a date or datetime value.
For the - operator, INTERVAL expr type is allowed only on the right side,
because it makes no sense to subtract a date or datetime value from an
interval. (See examples below.)
mysql SELECT '1997-12-31 23:59:59' + INTERVAL 1 SECOND;
- '1998-01-01 00:00:00'
mysql SELECT INTERVAL 1 DAY + '1997-12-31';
- '1998-01-01'
mysql SELECT '1998-01-01' - INTERVAL 1 SECOND;
- '1997-12-31 23:59:59'
mysql SELECT DATE_ADD('1997-12-31 23:59:59',
- INTERVAL 1 SECOND);
- '1998-01-01 00:00:00'
mysql SELECT DATE_ADD('1997-12-31 23:59:59',
- INTERVAL 1 DAY);
- '1998-01-01 23:59:59'
mysql SELECT DATE_ADD('1997-12-31 23:59:59',
- INTERVAL '1:1' MINUTE_SECOND);
- '1998-01-01 00:01:00'
mysql SELECT DATE_SUB('1998-01-01 00:00:00',
- INTERVAL '1 1:1:1' DAY_SECOND);
- '1997-12-30 22:58:59'
mysql SELECT DATE_ADD('1998-01-01 00:00:00',
- INTERVAL '-1 10' DAY_HOUR);
- '1997-12-30 14:00:00'
mysql SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);
- '1997-12-02'
mysql SELECT DATE_ADD('1992-12-31 23:59:59.02',
-INTERVAL '1.99' SECOND_MICROSECOND);
- '1993-01-01 00:00:01.01'
If you specify an interval value that is too short (does not include
all the interval parts that would be expected from the type keyword), MySQL
assumes that you have left out the leftmost parts of the interval value.
For example, if you specify a type of DAY_SECOND, the value of expr is
expected to have days, hours, minutes, and seconds parts. If you specify a
value like '1:10', MySQL assumes that the days and hours parts are missing
and the value represents minutes and seconds. In other words, '1:10'
DAY_SECOND is interpreted in such a way that it is equivalent to '1:10'
MINUTE_SECOND. This is analogous to the way that MySQL interprets TIME
values as representing elapsed time rather than as time of day.
If you add to or subtract from a date value something that contains a
time part, the result is automatically converted to a datetime value:
mysql SELECT DATE_ADD('1999-01-01', INTERVAL 1 DAY);
- '1999-01-02'
mysql SELECT DATE_ADD('1999-01-01', INTERVAL 1 HOUR);
- '1999-01-01 01:00:00'
If you use really malformed dates, the result is NULL. If you add
MONTH, YEAR_MONTH, or YEAR and the resulting date has a day that is larger
than the maximum day for the new month, the day is adjusted to the maximum
days in the new month:
mysql SELECT DATE_ADD('1998-01-30', INTERVAL 1 MONTH);
- '1998-02-28'
Thank you,
At 07:47 PM 11/16/2005, Petr Chardin wrote:
http://bugs.mysql.com/bug.php?id=8523
Ehrwin C. Mina
9/F Tower 2
RCBC Plaza
6819 Ayala Avenue cor. Sen. Gil J. Puyat Avenue
Makati City 1200 Philippines
Cell (63 918) 930 4383
Tel/Fax(63 2) 757 2633
Email [EMAIL PROTECTED]
Webwww.chikka.com
This message and any attachment are confidential and may be privileged
Re: Tracking changes in the database
You can also set a plain logging of mysql activity by enabling this in my.cnf log= /tmp/mysqld.log tmpdir = /tmp/ restart mysql Thanks, At 02:32 PM 10/13/2005, Daniel Kasak wrote: Andre Matos wrote: I am using InnoDB and replication, is there any issues? Thanks. Andre It depends what you're doing. If you use the binary log, there are no issues - in replication uses the binary log to achieve it's goals. Since the plain-text log is depreciated, you probably should learn to use the binary log. As I noted before, the plain-text log has some issues. I'm not sure what all of them are, but I've encountered issues when using plain-text logs and temporary tables ( eg 2 users create temporary tables - in the plain text log, it looks like the 1 user ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Ehrwin C. Mina 9/F Tower 2 RCBC Plaza 6819 Ayala Avenue cor. Sen. Gil J. Puyat Avenue Makati City 1200 Philippines Cell (63 918) 930 4383 (63 917) 845 2102 Tel(63 2) 757 2633 Fax(63 2) 757 2633 Email [EMAIL PROTECTED] Webwww.chikka.com This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: ADDING MYSQL DATABASE
HI, If you want i can send you the help file so you dont need to browse anytime you need a command in mysql. Thank you, ehrwin At 03:13 PM 8/22/2005, Gu Lei wrote: Hi That's a problem about privileges. Try mysql -uroot. Please have a look at http://dev.mysql.com/doc/mysql/en/privilege-system.html and http://dev.mysql.com/doc/mysql/en/user-account-management.html regards On 2005Äê08ÔÂ20ÈÕ 14ʱ46·Ö26Ãë, tai huijia wrote: Greetings, I'm a new user for MYSQL and I face problem adding mysql database. After typing: SHOW DATABASES; I got this: +--+ | Database | +--+ | test | +--+ 1 row in set (0.02 sec) which does not contain mysql and tmp as shown: +--+ | Database | +--+ | mysql| | test | | tmp | +--+ How can I create mysql database? I have gone through the manual provided, but I don't really understand the way to create it. Please guide me. THANK YOU! __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Ehrwin C. Mina 9/F Tower 2 RCBC Plaza 6819 Ayala Avenue cor. Sen. Gil J. Puyat Avenue Makati City 1200 Philippines Cell (63 918) 930 4383 (63 917) 845 2102 Tel(63 2) 757 2630/32 Fax(63 2) 757 2633 Email [EMAIL PROTECTED] Webwww.chikka.com This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql command line execution
At 09:49 PM 7/29/2005, Nuno Pereira wrote: Michael Stassen wrote: Ehrwin Mina wrote: Jeff, You can make a shell script or a php script or a perl script by that way you can hide the commands you need to execute. eg. Make a shell script (myshell.sh) #!/bin/sh myuser=dbuser mypasswd=dbpassword mydb=dbname myhost=localhost myport=3306 db1=mysql -u$myuser -pmypasswd -Dmydb -h$myhost -P$myport echo repair table employee | $db1 echo unlock table | $db1 exit This is no more secure, as it still puts the password on the command line. Your script amounts to echo repair table employee | mysql -udbuser -pdbpassword -Ddbname -hlocalhost -P3306 echo unlock table | mysql -udbuser -pdbpassword -Ddbname -hlocalhost -P3306 The password is on the command line of the commands issued by the script, so it can be seen with ps. That isn't true. If you make a ps, you will see something like mysql -p x . As I said before, you can use something like: mysql -uUser --password=`cat password_file` db See http://lists.mysql.com/mysql/186720. But ensure that the password_file has access restrictions like -r, so that only the owner can read it. The solution is to put the password in an option file (usually .my.cnf) instead. The client, mysql, will read the password from the option file, without making it available to ps. Michael -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] FYI, Nuno is correct you cannot see the password in the 'ps' and my scripts is just an example you can modify it for more security like putting it a config file or much better if you can use perl. Don't forget the user privileges only. Thanks, Ehrwin C. Mina 9/F Tower 2 RCBC Plaza 6819 Ayala Avenue cor. Sen. Gil J. Puyat Avenue Makati City 1200 Philippines Cell (63 918) 930 4383 (63 917) 845 2102 Tel(63 2) 757 2630/32 Fax(63 2) 757 2633 Email [EMAIL PROTECTED] Webwww.chikka.com This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql command line execution
Jeff, You can make a shell script or a php script or a perl script by that way you can hide the commands you need to execute. eg. Make a shell script (myshell.sh) #!/bin/sh myuser=dbuser mypasswd=dbpassword mydb=dbname myhost=localhost myport=3306 db1=mysql -u$myuser -pmypasswd -Dmydb -h$myhost -P$myport echo repair table employee | $db1 echo unlock table | $db1 exit 2. Grant the user for its privileges. 3. change the permission of the file. 4. run the shell like this sh myshell.sh At 10:09 AM 7/29/2005, Jeff Richards wrote: Hi, Is there a secure way of running mysql commands against the db from the command line, or in some kind of secure batch mode, without making the password totally visible? We need to procedurize things like flush tables with read lock, unlock tables etc. Is making the password visible on the command line the only way? Thanks, Jeff -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Thank you, Ehrwin C. Mina 9/F Tower 2 RCBC Plaza 6819 Ayala Avenue cor. Sen. Gil J. Puyat Avenue Makati City 1200 Philippines Cell (63 918) 930 4383 (63 917) 845 2102 Tel(63 2) 757 2630/32 Fax(63 2) 757 2633 Email [EMAIL PROTECTED] Webwww.chikka.com This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to the mysql server.thank you.
wrote: dear sir, nice to meet you. now i have installed the MySQL-ServerClient(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. In what platform did you install it? thanks, Ehrwin Mina Chikka Asia Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. Yap, it is posible to dump the file in a linux machine but you must import it first into a windows mysql and later you dump it to a linux macine mysql. - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Ehrwin Mina [EMAIL PROTECTED] Subject: Re: How to import data from Dbase3? Date: Wed, 23 Mar 2005 02:21:48 -0600 Ehrin, If you have dBase III or later, Clipper or FoxPro, you can export the data comma-separated, then use a free csv-to-mysql utility eg http://sourceforge.net/projects/csv-mysql/ to get it into mysql. If you don't have an xbase executable, it's a little harder, but not much provided there's no memo file. A dbase data file is an ASCII file with a binary header. You can read the header in any file viewer, observe the header size, and find the field names lengths. The data is entirely ASCII, padded to exact col lengths, thus simple to parse with a perl or php script. If there's a memo file, you need an xbase executable. PB - Ehrwin Mina wrote: BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- *Ehrwin C. Mina* */Chikka Asia, Inc. /* *9/F RCBC Plaza Tower 2 6819 Ayala Avenue Makati City, Philippines hp1: +639189304383 hp2: +639178452102* *tel: +63-2-757-2630 fax: +63-2-757-2633 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *URL: **http://www.chikka.com* mailto:[EMAIL PROTECTED] *This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- *Ehrwin C. Mina* */Chikka Asia, Inc. /* *9/F RCBC Plaza Tower 2 6819 Ayala Avenue Makati City, Philippines hp1: +639189304383 hp2: +639178452102* *tel: +63-2-757-2630 fax: +63-2-757-2633 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *URL: **http://www.chikka.com* mailto:[EMAIL PROTECTED] *This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045
hi jernej, using this command is normal: mysql -h localhost -u jk -p ENTER but you have to check the grants/permission you set to a particular database name, username with its password. use the manual for more info regarding grants. thanks, Ehrwin Miña Senior System Administrator NOC Chikka Asia, Inc. - Original Message - From: James E Hicks III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 22, 2004 9:33 PM Subject: Re: Error 1045 my On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote: My first contact with MySQL. When I try to login with the following two lines, I get an error code 1045 mysql -h localhost -u jk -p ENTER PASSWORD: password ERROR 1045: Access denied for user: [EMAIL PROTECTED] using password: YES Please help. [EMAIL PROTECTED] Mysql userids/passwords have nothing to do with OS userids/passwords. http://dev.mysql.com/doc/mysql/en/User_Account_Management.html James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
