Re: Access denied/password change

/en/access-denied.html http://dev.mysql.com/doc/mysql/en/resetting-permissions.html Seena Blace [EMAIL PROTECTED] wrote: [-- text/plain, encoding 8bit, charset: iso-8859-1, 17 lines --] Hi, I have been noticing following error when trying to connect mysql. ERROR 1045

Access denied

Hi, I have been noticing following error when trying to connect mysql. ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) or ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) What could be reason? Is there any way I can connect to

CONCAT

hi, how to concat 2 columns to display in report? select column1concat column2 form table1; Concatenation Operator pl? thanks - Discover Yahoo! Stay in touch with email, IM, photo sharing more. Check it out!

Re: QUERY (TOP)

ordering customers per year, as expected. So I am unclear why the algorithm does not work for your spam table. PB - Seena Blace wrote: Peter here u go.just a few.You may see sample report. 2005-05-05 | 1108529 | 0 | 1 |0 | 0

Re: QUERY (TOP)

and explain to me what's wrong so I can fix it. Thank you for your patience, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace wrote on 05/16/2005 04:41:19 PM: Shawn, query SELECT * FROM spam_stats WHERE rank = 10; will return all rows which I don't want. I need

Re: QUERY (TOP)

Any suggestion pl? Seena Blace [EMAIL PROTECTED] wrote:hi, here is table description report1 +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra

output in text file /migration

Hi, I want to migrate 1 table from MYSQL to oracle ? how to do that ? How to get output of table into text file? thanks . - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone.

Re: QUERY (TOP)

..like that upto 10 Each day there are multiple entry from diffrent domains or same domain. I want each day whatever top 10 spam sender domain. thanks [EMAIL PROTECTED] wrote: Seena Blace wrote on 05/16/2005 10:08:15 AM: Any suggestion pl? Seena Blace wrote:hi

Re: select count(*) table

just give a it try select count(columnname) from table; Eric Bergen [EMAIL PROTECTED] wrote:select count(*) table; gives me a syntax error in 4.0 and 4.1 so I'm not sure how that worked. Something similar would be select count(*) t; which uses the shortcut alias syntax. It's the same as doing

repair table/close table ?????

Hi, Here is what I see. mysql check table report_1; +---+---+--++ | Table | Op| Msg_type | Msg_text |

Re: QUERY (TOP)

[EMAIL PROTECTED] wrote: Seena Blace wrote on 05/16/2005 11:13:48 AM: shawn I think 2nd query will return only 10 rows. I want out like followings date domain spam 05/05/05 hotmail.com 120 05/05/05 yahoo.com 110 05/05/05 abc.com 99 05/05/05 def.com 80 05/05/05 mnpo.net 79

QUERY (TOP)

hi, here is table description report1 +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

TOP N record

Hi, how to get top N records from table ? columns of table id date1 process wip worm I need output date1 process wip worm 5/5/05 5/6/05 5/7/05 thanks - Do you Yahoo!? Yahoo! Mail - Find

RE: table optimisation

How to check whae are tables are having how many indexes on which columns ? Thomas Sundberg [EMAIL PROTECTED] wrote: -Original Message- From: Seena Blace [mailto:[EMAIL PROTECTED] Sent: den 11 maj 2005 23:58 To: mysql@lists.mysql.com Subject: table optimisation Hi, I have been

Re: Report(query)

ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using date_format(nameofcolumn,'%Y-%m-%d')? Harald Fuchs [EMAIL PROTECTED] wrote: In article [EMAIL PROTECTED], Seena

table optimisation

Hi, I have been noticing table performanace issue when # of rows grows more.How to tune that table? thanks -Seena - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard.

Report(query)

Hi, I want report like this Table description is like as follows Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id |

MIGRATION OF DATABASE FROM ONE BOX TO ANOTHER BOX

Hi, How to migrate mysql database from one box to another box ? thanks -Seena - Do you Yahoo!? vote.yahoo.com - Register online to vote today!

AUTO_INCREMENT

Hi, Is there any way AUTO_INCREMENT column cann't me Primary key ? One table has one column auto_increment which I want to convert into non primary key but I also want to maintain the column.How to do that? thanks - Do you Yahoo!?

MYSQL CONNECT ISSUE

I have been getting following error. [polaris] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) How to fix that? What is default port for mysqlserver? thx -seena - Do you Yahoo!? New and Improved Yahoo! Mail - 100MB

Re: Database connectivity

Hi, I wanted to setup connectivity between mysql database and oracle database.I have one database in mysql from which all tables data I want to insert real time data into oracle database.How to connect mysql database with oracle database? thanks

Table dump into binary

into valid Oracle statements. Other than that, I think that you would need to periodically poll the MySQL server for changes and duplicate them into your Oracle server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace wrote on 09/01/2004 12:30:12 PM: Hi, I

Connectivity

Hi, I have one mysql database and one oracle database.I want to fetch data from mysql db to oracle db in realtime.How to do this? I also wanted to tarnsfer 14 tables from one mysql database to Oracle how to do this? thanks - Do you Yahoo!? New

Database connectivity

Hi, I wanted to copy setup some procedure which pickup data from mysql and load into oracle database.How to do this? I would also like to know how to establish a connection between mysql and oracle database? thanks - Do you Yahoo!? Win 1 of

MYSQLOUTPUT

Hi, I'm getting output like select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from host a,ipdet_temp1 b,makemodel c,software d,hsdet e - where a.hostid=b.hostname2 and a.makemodel=c.makemodelid and a.hostid=e.host_id and e.software_id=d.softwareid and

Re: MYSQLOUTPUT

[EMAIL PROTECTED] wrote: Are you just wanting to remove the header information? If so, then try mysql --skip-column-names On Thu, 01 Apr 2004, Seena Blace wrote: Hi, I'm getting output like select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from host a,ipdet_temp1 b,makemodel c

Re: ORDER BY WITH NO PRINT

Seena Blace [EMAIL PROTECTED] wrote:Hello, I want to show outpur like this? Group hostname details aa abababa aa abababababab aa anannanananna bb llololololool bb ssjjsjsjsjjsjsj Select group,hostname,details from table1 order by group; I want

ORDER BY WITH NO PRINT

Hello, I want to show outpur like this? Group hostname details aa abababa aa abababababab aa anannanananna bbllololololool bb

How to prompt variable

Hi, i want to update couple of columns like update tablename set =value1 where columname=value2; I want to run query on mysql prompt each time and enter value1 and value2 for diffrent columnname ? Value1 and value2 will be diffrent. in oracle we use to prompt value. thx Do you Yahoo!? Yahoo!

PHP and Mysql

Hi, Does any one help me in formating the output result in PHP with mysql? The code is here. form action=hostrep.php method=get /form ? $username=root; $password=; $database=databasename; $host=localhost; $today = date(F j, Y, g:i a); mysql_connect($host,$username,$password);

COMPOSITE PRIMARY KEY?

Hi, I want to create a table with composite Primary key.How to do that? create table ipdet (IPaddress varchar (14) not null , hostid varchar (20) not null primary key (ipaddress,hostid), IP_DESC text , MAC text, interface text); thx-seena - Do

Migration from windows to linux red hat

Hi, I have 10 tables which I want to migrate from windows mysql(V4.0.17) to red hat mysql(V3.23.54).How to do that pl? Some tables are having real data also. thx -seena - Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online

HOW TO RUN SQL and default value ?

Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do

HOW TO RUN SQL

on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: maandag 9 februari 2004 22:14 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] HOW TO RUN SQL and default value ? Hi, How to run script

MYSQL (SQL ERROR)

Hi, I'm using Win2k,Apache,PHP(V4) and mysql . When I'm running php page ,noticing error Notice: Undefined variable. Let me know how to fix pl? thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

PHP AND MYSQL

Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: form action=insert.php method=post Software id: input

Re: PHP AND MYSQL

like: $softwareid = $_POST[softwareid]; $manufacturer = $_POST[manufacture]; etc, etc... Plus...are you able to connect to the db server? Use: mysql_connectd($host, $username, $password); -- Jason On Mon, 2004-02-02 at 16:07, Seena Blace wrote: Hi, Does any one develop any web pages with PHP

SQL CONNECTIVITY

Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have installed linux9,apache 2.0, php. thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building

RE: [Mysql-discussions] SQL CONNECTIVITY

PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP. Fatal error: Call to undefined function: mysql_connect() Let me know how to fix that.I have installed

RE: [Mysql-discussions] SQL CONNECTIVITY

on the hackerscene -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: vrijdag 30 januari 2004 17:12 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] SQL CONNECTIVITY Hi all, I have been noticing following error message with PHP. Fatal

Re: MYSQL Database

Which version of PHP would be good for Red hat 7.3? can someone send URL from where I can download the php pl? Jochem van Dieten [EMAIL PROTECTED] wrote:Douglas Sims wrote: You should check out: http://onlamp.com/ L.A.M.P. (Linux/Apache/MySQL/Perl(or PHP) Or

SELECT

Hi, How to see all tables in connected database? thx -seena - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes

MYSQL Database

Hi, I'm new to this group.I would like to know which frontend tools be good tuned with Mysql database like php,perl etc? I want to develop one application on linux on mysql database which eventually would be webbased.Please suggest what combination would be good. thx -Seena

MYSQL Database

Hi, I'm new to this group.I would like to know which frontend tools be good tuned with Mysql database like php,perl etc? I want to develop one application on linux on mysql database which eventually would be webbased.Please suggest what combination would be good. thx -Seena