Re: Help NEWBIE!
try passing the --host param to specify the ip address of the MySQL server. Lets say that you have MySQL running on 192.168.1.105 $ mysql --host=192.168.1.105 -u username -p do a man mysql for more info SK On Sat, 2003-05-31 at 15:34, ABHIJIT NAIK wrote: Dear Friends, I am new user of MySQL and whenever I type mysql to start the ware it simply states -- Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock'. I know I am doing something very wrong here and mabe some of you might be able to help me solve this problem. I am running a SuSE Linux 8.2 version AMD Duron machine and already have a subscription to my ISP to access their database. ALso, the file mysql.sock does not exist in the mysql folder. Thanking you all very much for your kind help. Sincerely, ABHIJIT NAIK -- 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]
Re: Find out what version I am using?
$ mysql --version On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote: Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- 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]
Re: [PHP] Encrypted MySQL passwords
http://www.stunnel.org/examples/mysql.html SK mysql, sql, query On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote: I am connecting to a mysql server on a remote machine, and opened up port 3306 for this purpose. But, I am concerned about sending a clear text password, via the mysql_pconnect() call. My question is, what is the procedure for connecting to a remote server with an encrypted password? Or, does mysql_pconnect handle this? Nope, it's all in the clear. MySQL 4.0 has support for doing this over SSL, I think. ---John Holmes... - 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
UPDATE help
Greetings, I am currently working on a table that has a column called state and a column called stateid. All 42,000 records in this table have a 2 Letter abbreviation for that state (NY, CA, NV, etc) however. To eliminate redundancy, I have move the states to another table that contains an AUTO_INCREMENT field, the state abbr and the state name. A typical record looks like this 1,NY,New York I want to remove the city.state column from the and populate the city.stateid with values from state.id Does anyone have any ideas on how to build an UPDATE statement that will SELECT id FROM state WHERE state = city.state? Many Thanks SK mysql, 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
Re: Problem starting mysqld on SCO
did you run the mysql_install_db script to create the mysql database and populate it with the bare values necessary for mysql run? SK On Thursday, September 5, 2002, at 05:57 PM, Darryl Hoar wrote: Greetings, I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website. I installed it per the INSTALL-BINARY readme file. When I try (from /usr/local/mysql) issue: bin/safe_mysqld --user=mysql It starts and immediately stops mysqld. The .err file contains 020904 21:41:45 mysqld started 020904 21:41:45 bdb: /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql-max-3.23.42-pc- sco3.2v5.0.6-i386 /data/log.01: Permission denied 020904 21:41:45 bdb: PANIC: Permission denied 020904 21:41:45 Can't init databases 020904 21:41:45 mysqld ended I have changed the ownership/group as per the instructions and I even went so far as to set the permission on the data directory to 777. Still no joy. Any ideas what step I missed? thanks in advance, Darryl - 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 mysql-unsubscribe- [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: Auto Increment ID of Inserted Row
SELECT MAX(id_field) FROM table SK On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote: What is the SQL to get the created AutoInc ID from a row that I have just inserted? Tim Davis Sunbelt Systems Concepts, Inc [EMAIL PROTECTED] Client/Server Database Programmer/Analyst - 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
Unsure of SQL Syntax
I am working with a MySQL database and I am hoping someone can help me out with this. CREATE TABLE CLASS ( CID int(22) NOT NULL auto_increment, LOC int(11) default NULL, CLI int(8) NOT NULL default '0', TYPE tinyint(4) NOT NULL default '0', STATUS char(3) NOT NULL default '', UID int(22) NOT NULL); CREATE TABLE GROUP ( GRID int(11) NOT NULL auto_increment, NAME varchar(40) NOT NULL default '', MAXACT int(11) NOT NULL default '0', LEVEL int(11) NOT NULL default '0', ADMIN int(22) NOT NULL default ''); Now I need to update the class table: set the CLASS.UID field to the `GROUP`.ADMIN field (join them on CLASS.CLI=`GROUP`.GRID) if CLASS.UID=2 and `GROUP`.GRID1. What would that SQL syntax look like? Thanks SK - 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: Help!! Extreme newbie
what is the error message you are getting? Is the MySQL server running on the same machine you are trying to connect to or are you connecting to a remote machine? On Tuesday, September 3, 2002, at 09:40 PM, Al Davis wrote: SK Being new to MYSQL as well as this list, I'm hoping you'll forgive what I'm sure will be a rather dumb question... I just installed mysql on a new install of SUSE 8.0 and every time I try to connect to the mysql server as a non root use I am denied access..have changed passwords, granted permissions, flushed permissions and yet nothing seems to work... Any suggestions? Thanks, Al Davis AKA extreme mysql/linux newbie - 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 mysql-unsubscribe- [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
INSERT Question
Hello All, First, Let me start by saying this question has most likely been asked before, but I did a search in the archive and was unable to come up with any results. I think this is because I am not quite sure what this is called. So, I do apologize, but hopefully this can be answered quickly and will really help me out. This is more of a General SQL question, regarding sytanx. I have 3 table I am going to be working on. contact, address and state. state contains 51 states (Washington D.C is listed as a state) each with their unique ID. Contact contains a persons first and last name, as well as their own ID. Address contains their street name, the city, state and a column called contactid for the id of the person who lives there. State is a foreign key for the state table and contactid is a foreign key for the contact's id. Now here is what I want to do: I want to insert a person into the contact database and then insert their address into the address table, but I want to somehow put the ID of the state, and the id of the contact into the fields without actually having to know the values. Like rather then having to look up New York and then insert 033, can I just somehow put New York? Is this possible to do? Many thanks -Steven mysql, 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
Re: Web Buttons and Command Line Instructions
what you would have to do is have that button run a CGI script of some sort that connects to the mysql server and performs the action. you could also use php for this Jamie Buck wrote: Is there a way to develop buttons on a webpage that can send command line instructions to MySQL, such as to run a script in a file that already exists on the server? The command line instruction would be as follows: mysql database_name file_name Is it feasible to get this sent to MySQL through a button? - 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