Re: [MyODBC]Access denied for user: 'ODBC@localhost'
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a user ODBC@localhost fixed it. all off a sudden i need a user named ODBC@localhost, and last i checked, i'm the only one here that knows anything about how to use mysql here at the office. so what might have been changed that would cause this. MyODBC has the correct username/password for the databases it uses. MS Access can open the ODBC databases without any problems (before i created the ODBC@localhost) its only the web server that seems to need the user. (ColdFusion PHP) and how do i change it back to not need the odbc@localhost user anymore (again)? and it turns out (just to mislead me even more...) Mozilla 1.0 running on linux isn't working correctly with phpmyadmin using cookie auth. (don't know if its just me, or just mozilla...) after login in, it shows me 2 frames, both with login screens. On Thursday 06 June 2002 8:39, you wrote: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:39). Date/Time: 06/06/02 06:34:43 Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 it was working fine yesterday... what is probably the problem? also i can't use phpMyAdmin anymore from the same machine. i can use the command line mysql just fine though. its running off of a win2k machine - 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 -- To one large turkey add one gallon of vermouth and a demijohn of Angostura bitters. Shake. -- F. Scott Fitzgerald, recipe for turkey cocktail. - 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: is there a whoami for mysql?
mysql select user(); +---+ | user()| +---+ | [EMAIL PROTECTED] | +---+ mysql show grants for [EMAIL PROTECTED]; ERROR 1141: There is no such grant defined for user 'root' on host '192.168.0.17' mysql show grants for user(); ERROR 1064: You have an error in your SQL syntax near 'user()' at line 1 mysql select user,host from mysql.user where user='root'; +---+---+ | user | host | +---+---+ | root | % | | root | 192.168.0.0/255.255.255.0 | | root | localhost | +---+---+ in theory i should be logged in [EMAIL PROTECTED]/255.255.255.0, but i've been wrong before... is there a way to just get which user/host set is being used? On Monday 03 June 2002 9:28, you wrote: Hi Ray, You can see what user you is with: select user(); Ray wrote: is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me Current user: [EMAIL PROTECTED] but show grants for [EMAIL PROTECTED]; says there are no grants for this account. also, i could see this coming up for debugging as a big help. note: all ips and usernames have been changed to protect the incredably insecure, and maybe a bit paranoid. sql,query - 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 -- The best cure for insomnia is to get a lot of sleep. -- W. C. Fields - 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
smaller mysql docs?
is there a place to get the manual that is split a bit more then the current manual_split. these are the 2 pages i end up reading the most even though its usually for just the grant, create, insert syntax (human in need of memory upgrade) 416k Sep 26 2001 manual_MySQL_Database_Administration.html 312k Sep 26 2001 manual_Reference.html i'm not sure what's wrong with my computer, but loading the pages takes a while from the local harddrive, or maybe its rendering the page... either way, the larger pages are annoyingly slow. or is there a cheat sheet page? (syntax, links into the manual, not much else) -- Bill Dickey is learning me his experience. -- Yogi Berra in his rookie season. - 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: Auto increment (Newbie)
manual_Reference.html#CREATE_TABLE create_definition: col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference_definition] create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20)); can't seem to find the ref right now, but insert into MyTestTable(555,'Ryan'); insert into MyTestTable (name) values ('Ryan'); or insert into MyTestTable values (null, 'Ryan'); On Thursday 30 May 2002 3:43, you wrote: Hey there, I know this might sound like a stupid question to a lot of you guys out there but please keep in mind I come from an oracle background and am new to this: I am accessing MySql from PHP, I have two questions regarding Auto_Increment 1) how to create an auto_increment? create table MyTestTable(cno int, name varchar(20)); works fine, but I want cno as an auto_increment, what statement to use? 2)to insert int into my example I will use insert into MyTestTable(555,'Ryan'); How would I do it if I was entering data and the cno was an auto increment? I have glossed through the manual, but frankly after 6 hours of PHP programming i'm feeling braindead so PLEASE dont ask me to RTFM, if you have links to the specific topic in the manual no problem, just tired of searching. Cheers all, -Ryan. - 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
is there local outfile?
is there a way or possibly a command line tool for querying a remote file and having it dump the select into a local outfile. it does exacly what i want from the server, but only to create a file on the server. and just adding local doesn't/hasn't work. and mysqldump outputs sql, which isn't what i'm looking for either. SELECT blah, blah2, blah3 . INTO LOCAL OUTFILE 'blubering.txt' FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' FROM chatter_table; -- If there are self-made purgatories, then we all have to live in them. -- Spock, This Side of Paradise, stardate 3417.7 - 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