Re: MySQL Newbie: Running in UNIX
Hello. Try to connect as root (use -u root) or another user which has privilege to create new databases. I would like to try out MySQL on my UNIX account (Solaris). I DO NOT HAVE root privilieges in UNIX. I only have a normal user privilege. I have installed MySQL on my user UNIX account. Looks like I get the Server going and can also get the status from the Server. But, I get an error msg when I try to create a database. I have attached the unix screen dump below. Any help will be greatly appreciated. Thanks, -Ashfaq Hossain / UNIX screen dump / Unix System / unix uname -a SunOS 5.8 Generic_108528-24 sun4u sparc SUNW,Sun-Fire-880 / Running MySQL Processes / unix ps -ef | grep mysql ashfaq 22040 22015 0 11:13:23 pts/63 0:00 /home/ashfaq/MySQL/mysql-standard-4.1.7-sun-solaris2.9-sparc-64bit/bin/m ysqld - ashfaq 14026 9830 0 11:18:08 pts/63 0:00 grep mysql ashfaq 22015 9830 0 11:13:23 pts/63 0:00 /bin/sh ./bin/mysqld_safe / Starting the Client / unix bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.1.7-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. / Checking Status / mysql status -- bin/mysql Ver 14.7 Distrib 4.1.7, for sun-solaris2.9 (sparc) Connection id: 7 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Using delimiter:; Server version: 4.1.7-standard Protocol version: 10 Connection: Localhost via UNIX socket Server characterset:latin1 Db characterset:latin1 Client characterset:latin1 Conn. characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 8 min 0 sec Threads: 1 Questions: 24 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.050 / / / Error Message : Please HELP! / / / mysql create database info ; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'info' ThreadHossain, Ashfaq (Ashfaq) [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Newbie: Running in UNIX
Restart mysqld with the --skip-grant-tables option and then try Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Thanks. But, it confuses the unix root with the mysql root. I don't have the unix root previleges. Am I doing something wrong? Here is the error: unix bin/mysql -uroot ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Newbie: Running in UNIX
Fix your mysql privileges http://dev.mysql.com/doc/mysql/en/GRANT.html DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Hossain, Ashfaq (Ashfaq) [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 8:39 AM To: [EMAIL PROTECTED] Subject: MySQL Newbie: Running in UNIX I would like to try out MySQL on my UNIX account (Solaris). I DO NOT HAVE root privilieges in UNIX. I only have a normal user privilege. I have installed MySQL on my user UNIX account. Looks like I get the Server going and can also get the status from the Server. But, I get an error msg when I try to create a database. I have attached the unix screen dump below. Any help will be greatly appreciated. Thanks, -Ashfaq Hossain / UNIX screen dump / Unix System / unix uname -a SunOS 5.8 Generic_108528-24 sun4u sparc SUNW,Sun-Fire-880 / Running MySQL Processes / unix ps -ef | grep mysql ashfaq 22040 22015 0 11:13:23 pts/63 0:00 /home/ashfaq/MySQL/mysql-standard-4.1.7-sun-solaris2.9-sparc-64bit/bin/m ysqld - ashfaq 14026 9830 0 11:18:08 pts/63 0:00 grep mysql ashfaq 22015 9830 0 11:13:23 pts/63 0:00 /bin/sh ./bin/mysqld_safe / Starting the Client / unix bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.1.7-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. / Checking Status / mysql status -- bin/mysql Ver 14.7 Distrib 4.1.7, for sun-solaris2.9 (sparc) Connection id: 7 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Using delimiter:; Server version: 4.1.7-standard Protocol version: 10 Connection: Localhost via UNIX socket Server characterset:latin1 Db characterset:latin1 Client characterset:latin1 Conn. characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 8 min 0 sec Threads: 1 Questions: 24 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.050 / / / Error Message : Please HELP! / / / mysql create database info ; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'info' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Newbie: Running in UNIX
This did not mean that's how you should work. I had this suggestion to confirm my doubt that something in the user table of mysql is messed up This was to allow you to setup a password for root or maybe another user (who can create) and then switch back to normal mysqld startup, to enable grant privs. Thanks Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Restart mysqld with the --skip-grant-tables option . Thanks. This suggestion works. Does it also mean I am skipping the grant-tables? -Original Message- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 12:57 PM To: Hossain, Ashfaq (Ashfaq) Subject: Re: MySQL Newbie: Running in UNIX log in as root mysql -uroot then you are the boss Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: I would like to try out MySQL on my UNIX account (Solaris). I DO NOT HAVE root privilieges in UNIX. I only have a normal user privilege. I have installed MySQL on my user UNIX account. Looks like I get the Server going and can also get the status from the Server. But, I get an error msg when I try to create a database. I have attached the unix screen dump below. Any help will be greatly appreciated. Thanks, -Ashfaq Hossain / UNIX screen dump / Unix System / unix uname -a SunOS 5.8 Generic_108528-24 sun4u sparc SUNW,Sun-Fire-880 / Running MySQL Processes / unix ps -ef | grep mysql ashfaq 22040 22015 0 11:13:23 pts/63 0:00 /home/ashfaq/MySQL/mysql-standard-4.1.7-sun-solaris2.9-sparc-64bit/bin/ m ysqld - ashfaq 14026 9830 0 11:18:08 pts/63 0:00 grep mysql ashfaq 22015 9830 0 11:13:23 pts/63 0:00 /bin/sh ./bin/mysqld_safe / Starting the Client / unix bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.1.7-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. / Checking Status / mysql status -- bin/mysql Ver 14.7 Distrib 4.1.7, for sun-solaris2.9 (sparc) Connection id: 7 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Using delimiter:; Server version: 4.1.7-standard Protocol version: 10 Connection: Localhost via UNIX socket Server characterset:latin1 Db characterset:latin1 Client characterset:latin1 Conn. characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 8 min 0 sec Threads: 1 Questions: 24 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.050 / / / Error Message : Please HELP! / / / mysql create database info ; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'info' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number
On Thu, 2004-07-08 at 00:19, Paul DuBois wrote: At 22:34 +0530 7/7/04, Sanjay Arora wrote: I am using Mysql on RH Linux 9. I am getting the following error. Command and result are given below alongwith \s output for diagnostic purposes. I have created a dns database and am trying to create a user mysql user dns with all privileges on it. mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD dns; ERROR 1133: Password hash should be a 16-digit hexadecimal number OMIT the word PASSWORD. Thanks for replying. Query is executing now but does not seem to effect any changes in the database0 rows affected! How do I diagnose the problem? mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY dns; Query OK, 0 rows affected (0.78 sec) With regards and thanks. Sanjay. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number
Sanjay Arora wrote: On Thu, 2004-07-08 at 00:19, Paul DuBois wrote: At 22:34 +0530 7/7/04, Sanjay Arora wrote: I am using Mysql on RH Linux 9. I am getting the following error. Command and result are given below alongwith \s output for diagnostic purposes. I have created a dns database and am trying to create a user mysql user dns with all privileges on it. mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD dns; ERROR 1133: Password hash should be a 16-digit hexadecimal number OMIT the word PASSWORD. Thanks for replying. Query is executing now but does not seem to effect any changes in the database0 rows affected! It's counter-intuitive, but that's just what GRANT says when it succeeds. It either works or gives an error. How do I diagnose the problem? mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY dns; Query OK, 0 rows affected (0.78 sec) There's no problem. You could verify that your GRANT worked with a couple SELECTS: SELECT user, host, password FROM mysql.user WHERE user='dns'; SELECT user, host, db FROM mysql.db WHERE user='dns'; The first should verify that the dns user exists in the user table, the second should verify that the dns user has rights to the dns table. With regards and thanks. Sanjay. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql Newbie: Help requested...password hash should be a 16 digithexadecimal number
Sanjay Arora mailto:[EMAIL PROTECTED] on Wednesday, July 07, 2004 10:04 AM said: I am using Mysql on RH Linux 9. I am getting the following error. [snip] Database changed mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD dns; ERROR 1133: Password hash should be a 16-digit hexadecimal number copy and paste the error into google and try following the first link or click i'm feeling lucky. chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number
At 22:34 +0530 7/7/04, Sanjay Arora wrote: I am using Mysql on RH Linux 9. I am getting the following error. Command and result are given below alongwith \s output for diagnostic purposes. I have created a dns database and am trying to create a user mysql user dns with all privileges on it. mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD dns; ERROR 1133: Password hash should be a 16-digit hexadecimal number OMIT the word PASSWORD. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL newbie installation
Yes! Yes you can! Ahem Basically, MySQL is always a network-aware database whether connections come in via Named Pipes (blame Bill for those), TCP/IP, UNIX sockets or via the funky shared memory whatsit that was brought in with MySQL 4.1.x. All that will be happening in your case is that you'll just need to tell all of your applications and things that your computer is the database server, by specifying localhost as the database server. Chris [EMAIL PROTECTED] wrote: I wish to learn MySQL on my Linux box [SuSE 8.1] Can I install MySQL on my hard drive and use it for learning *from* the hard drive, without having to set up a server/network? This would include MySQLCC. In other words, can I run MySQL like Access, strictly as a local database, for learning purposes? I hope I'm not blaspheming. Thanks Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL newbie: table gone after reboot
Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
Can you post the contents from the todo directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:14 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
Okay, I had to log in as root to do so. The data seems to be still extant in tasks.MYD . The other 2 files, tasks.MYI and tasks.frm, are binary. -Avram [aa:local/mysql/data] aelony# ls -l todo total 40 -rw-rw 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD -rw-rw 1 mysql wheel 2048 Sep 23 18:46 tasks.MYI -rw-rw 1 mysql wheel 8819 Sep 23 00:56 tasks.frm On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote: Can you post the contents from the todo directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:14 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
Does the user who you start the MySQL Server up with own the directory and the files? If the files are there you can try issuing a `show tables from todo`. If the tables appear try running `check table tasks` and let us know what the output is. -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:37 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot Okay, I had to log in as root to do so. The data seems to be still extant in tasks.MYD . The other 2 files, tasks.MYI and tasks.frm, are binary. -Avram [aa:local/mysql/data] aelony# ls -l todo total 40 -rw-rw 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD -rw-rw 1 mysql wheel 2048 Sep 23 18:46 tasks.MYI -rw-rw 1 mysql wheel 8819 Sep 23 00:56 tasks.frm On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote: Can you post the contents from the todo directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:14 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
I have tried logging in as root ( mysql -p -u root todo ) and also as myself and both methods yield the same results, shown below: mysql SHOW TABLES FROM todo; ERROR 12: Can't read dir of './todo/' (Errcode: 13) mysql It continues to be curious... -A On Wednesday, September 24, 2003, at 08:22 AM, Victor Pendleton wrote: Does the user who you start the MySQL Server up with own the directory and the files? If the files are there you can try issuing a `show tables from todo`. If the tables appear try running `check table tasks` and let us know what the output is. -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:37 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot Okay, I had to log in as root to do so. The data seems to be still extant in tasks.MYD . The other 2 files, tasks.MYI and tasks.frm, are binary. -Avram [aa:local/mysql/data] aelony# ls -l todo total 40 -rw-rw 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD -rw-rw 1 mysql wheel 2048 Sep 23 18:46 tasks.MYI -rw-rw 1 mysql wheel 8819 Sep 23 00:56 tasks.frm On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote: Can you post the contents from the todo directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:14 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
The user `root` in MySQL is not the same as the Unix `root` user. The user, mysql, or whatever you have selected needs to own the directory and files in the todo directory. chown -R mysql todo chgrp -R mysql todo ... Error 13 means that the user that started the MySQL server does not have permission to access the todo directory. -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:33 PM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I have tried logging in as root ( mysql -p -u root todo ) and also as myself and both methods yield the same results, shown below: mysql SHOW TABLES FROM todo; ERROR 12: Can't read dir of './todo/' (Errcode: 13) mysql It continues to be curious... -A On Wednesday, September 24, 2003, at 08:22 AM, Victor Pendleton wrote: Does the user who you start the MySQL Server up with own the directory and the files? If the files are there you can try issuing a `show tables from todo`. If the tables appear try running `check table tasks` and let us know what the output is. -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:37 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot Okay, I had to log in as root to do so. The data seems to be still extant in tasks.MYD . The other 2 files, tasks.MYI and tasks.frm, are binary. -Avram [aa:local/mysql/data] aelony# ls -l todo total 40 -rw-rw 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD -rw-rw 1 mysql wheel 2048 Sep 23 18:46 tasks.MYI -rw-rw 1 mysql wheel 8819 Sep 23 00:56 tasks.frm On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote: Can you post the contents from the todo directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:14 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL newbie: table gone after reboot
Changing the ownership fixed everything. I did not realize there were multiple notions of 'root'. Thank-you, Avram On Wednesday, September 24, 2003, at 12:10 PM, Victor Pendleton wrote: The user `root` in MySQL is not the same as the Unix `root` user. The user, mysql, or whatever you have selected needs to own the directory and files in the todo directory. chown -R mysql todo chgrp -R mysql todo ... Error 13 means that the user that started the MySQL server does not have permission to access the todo directory. -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:33 PM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I have tried logging in as root ( mysql -p -u root todo ) and also as myself and both methods yield the same results, shown below: mysql SHOW TABLES FROM todo; ERROR 12: Can't read dir of './todo/' (Errcode: 13) mysql It continues to be curious... -A On Wednesday, September 24, 2003, at 08:22 AM, Victor Pendleton wrote: Does the user who you start the MySQL Server up with own the directory and the files? If the files are there you can try issuing a `show tables from todo`. If the tables appear try running `check table tasks` and let us know what the output is. -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:37 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot Okay, I had to log in as root to do so. The data seems to be still extant in tasks.MYD . The other 2 files, tasks.MYI and tasks.frm, are binary. -Avram [aa:local/mysql/data] aelony# ls -l todo total 40 -rw-rw 1 mysql wheel 1220 Sep 23 18:11 tasks.MYD -rw-rw 1 mysql wheel 2048 Sep 23 18:46 tasks.MYI -rw-rw 1 mysql wheel 8819 Sep 23 00:56 tasks.frm On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote: Can you post the contents from the todo directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:14 AM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie: table gone after reboot I am unfamiliar with frm, myd, and myi files, yet perhaps is insightful? -Avram [aa:/usr/local/mysql] % ls -l data total 41032 -rw-rw 1 mysql wheel 6362 Sep 23 22:55 aa.local..err -rw-rw 1 mysql wheel 25088 Sep 8 00:43 ib_arch_log_00 -rw-rw 1 mysql wheel 5242880 Sep 23 22:55 ib_logfile0 -rw-rw 1 mysql wheel 5242880 Sep 8 00:43 ib_logfile1 -rw-rw 1 mysql wheel 10485760 Sep 23 22:54 ibdata1 drwxr-x--- 20 mysql wheel 680 Sep 8 00:37 mysql/ drwx-- 8 mysql wheel 272 Sep 22 23:59 sampdb/ drwxr-x--- 5 mysql wheel 170 Sep 10 17:18 test/ drwx-- 2 mysql wheel68 Sep 10 17:11 testdb1/ drwx-- 5 mysql wheel 170 Sep 23 00:56 todo/ [aa:/usr/local/mysql] % The aa.local..err file contains lengthy text about starts,stops to the server and errors, the other files appear to be binary.. On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote: Are the frm, myd and myi files located in the data directory? What is the data directory? -Original Message- From: Avram Aelony [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: MySQL newbie: table gone after reboot I am new to MySQL and have encountered a problem that probably happens to everyone, yet I have searched for a solution online and elsewhere without success. I created a database and table. Then I populated the table. Everything worked perfectly. Then I shutdown MySQL and rebooted my computer. After starting mysqld, I now find my database, but the table and all its contents seem to be gone. 1.) Can I recover this table? 2.) How can I make sure this does not happen again? What did I do wrong? Is there an FAQ?? Thanks, Avram This is what I did... CREATE DATABASE todo; #Create tasks table for To Do list database CREATE TABLE tasks ( taskVARCHAR(60) NOT NULL, date_enteredTIMESTAMP(16) NOT NULL, date_dueDATE NULL, date_completed DATE NULL, priorityENUM(SOMEDAY, NOW, SOON) NOT NULL, description VARCHAR(255) NULL, taskid INT UNSIGNED NOT NULL AUTO_INCREMENT, keywordsVARCHAR(100) NULL, PRIMARY KEY (taskid) ); INSERT INTO tasks ( task, date_due, priority, description, keywords) VALUES(set up database,2003-09-24, SOON, set up the database, database); -- 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: MySQL Newbie: MySQL stops as soon as it starts
David Shealy [EMAIL PROTECTED] wrote: I don't know where the error log is. I used the -l option with safe-mysqld and this is what I got: /usr/libexec/mysqld, Version: 3.23.56-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument Error log is located in the MySQL data dir (/var/lib/mysql) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Newbie: MySQL stops as soon as it starts
What does the error log say? David Shealy wrote: I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running mysql_install_db, I switch to the directory where mysql.sock is located and enter safe_mysqld . Here's a copy of the shell output: # safe_mysqld [1] 7549 # Starting mysqld daemon with databases from /var/lib/mysql 030626 02:02:59 mysqld ended The cursor is flashing down on this line, and if I type anything and enter it kicks me back to the prompt. If I do a ps, it doesn't show anything about mysql even running. It appears to run for a split second and then end all by itself. I'm still trying to read all the man page stuff; would appreciate any help. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Newbie: MySQL stops as soon as it starts
I don't know where the error log is. I used the -l option with safe-mysqld and this is what I got: /usr/libexec/mysqld, Version: 3.23.56-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument On Wed, 2003-06-25 at 15:40, gerald_clark wrote: What does the error log say? David Shealy wrote: I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running mysql_install_db, I switch to the directory where mysql.sock is located and enter safe_mysqld . Here's a copy of the shell output: # safe_mysqld [1] 7549 # Starting mysqld daemon with databases from /var/lib/mysql 030626 02:02:59 mysqld ended The cursor is flashing down on this line, and if I type anything and enter it kicks me back to the prompt. If I do a ps, it doesn't show anything about mysql even running. It appears to run for a split second and then end all by itself. I'm still trying to read all the man page stuff; would appreciate any help. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Newbie
1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create special effects or special functions, similar to JavaScript.) If you found this list then you should have found information about MySQL. It's a database server ment for running relational databases. (short and simple explanation). You can use languages like Perl, PHP, Python and C to retrieve information. Tutorials: www.php.net --links-tutorials www.devshed.com www.mysql.com www.google.com (search) search this lists archive since it holds many many many other links. YOu will find hundreds of links if you search google. I'm not certain exactly what form this function will eventually take, but I'm just exploring ways to list vast amounts of data that are searchable, sortable or can be manipulated in other ways. If this can be done with MYSQL, can you give me an idea of how to get started? Is there a name for this function, a tutorial that describes it, or a webpage on the Internet that I can use as a model? You can do this with any language mentioned above. 3) Is a knowledge of MYSQL a great help in finding jobs and roughly how long does it take most people to acquire a working knowledge of it? With my skills, I don't expect to become a MYSQL pro any time soon, but I just wondered if even a basic knowledge might help with job searches. Depends on what a company is looking for. Some basic knowledge usually isn't enough. B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL Newbie
you probably want php which intergrates into mysql nicely, as mysql being the database for the content, http://www.php.net/ http://www.phpbuilder.com/ there is also some links on the php site u might want to check out http://www.php.net/links.php with mysql you prob want to master the sql queries to get the most optimised way to retrieve your data. these sites are good has alot of resources and helped me alot when i was a newbie http://www.weberdev.com/ http://www.devshed.com/ = Original Message From David Blomstrom [EMAIL PROTECTED] = I'm interested in learning about MYSQL and wondered if anyone could give me a few pointers for getting started. I've designed over 1,000 webpages, based at http://www.geobop.com, but my technical skills are very basic. I've been unemployed for about eight months and have been using my time to learn new computer skills while frantically trying to get my websites revised and moved to a new Linux server. I recently graduated from Microsoft FrontPage to DreamWeaver, upgraded from Windows Millennium to XP Professional and have been studying Cascading Style Sheets and JavaScript. I recently got Linux installed on my computer, though I haven't learned to use it yet. I'll be moving to a Linux ISP soon. Here are my first three questions: 1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create special effects or special functions, similar to JavaScript.) 2) I recently learned how to create tables with sortable columns using JavaScript, as illustrated by the example at http://www.geobop.com/marini/ I envision using something like MYSQL to create even more sophisticated tables, or alternatives. For example: Suppose I created a table listing every species of bird - about 10,000 species - with a dozen columns for the common name, scientific name, habitat, etc. Obviously, a page with such a table would take forever to download. But someone told me I could use MYSQL or another language to create an alternative that would display only a few rows at a time. I'm not certain exactly what form this function will eventually take, but I'm just exploring ways to list vast amounts of data that are searchable, sortable or can be manipulated in other ways. If this can be done with MYSQL, can you give me an idea of how to get started? Is there a name for this function, a tutorial that describes it, or a webpage on the Internet that I can use as a model? 3) Is a knowledge of MYSQL a great help in finding jobs and roughly how long does it take most people to acquire a working knowledge of it? With my skills, I don't expect to become a MYSQL pro any time soon, but I just wondered if even a basic knowledge might help with job searches. Thanks! -- 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: mySQL newbie confusion
...and your problem is? -- Loren McDonald [EMAIL PROTECTED] -Original Message- From: Fernando Martins [mailto:[EMAIL PROTECTED] Sent: Sunday, March 02, 2003 6:00 PM To: [EMAIL PROTECTED] Subject: mySQL newbie confusion Hi, my experience comes from VB6 with access databases. I'am trying to get one quick and practical overview about the mySQL capabilities (web online database). But so far i'am really loss and confuse regarding the mySQL setup and installation procedure. I'am using WIN98 with mySQL4.01.11 and follow step by step http://www.mysql.com/doc/en/index.html manual. So far i did install the mySQL and create the my.ini file in windows folder. [mysqld] basedir=C:\Progra~1\Mysql datadir=C:\Progra~1\Mysql\Data At this point i'am really confuse and thinking what dummy am i ... can someone help me please to turn this frustrating stage. Thanks Fernando - 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: Mysql newbie
I'm confused John. Since --with-mysql=shared,/usr' appears in the Configure Command table from phpinfo(), doesn't that mean php *was* compiled with mysql support? Ken At 12:03 AM 11/5/2002 -0500, John Coder wrote: On Mon, 2002-11-04 at 23:51, Ken Arck wrote: then it's compiled under dbx functions not mysql functions run configure again with the same arguments except for mysql just run --with-mysql and it should be ok. -As I said, it was installed from an rpm as part of the Redhat install package and not from a tarball. Are you saying to reinstall from a tarball after running configure? Either complile it from a tarball or get the src.rpm go in change the neccessary file in the src.rpm and compile it. ( which file I don't know). I personally know of no way to change your configure options without running make and make install. - 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 -- President - Arcom Communications Amateur Radio Station AH6LE Curious about the weather in Orygun? Check out http://www.ah6le.net/weather.html http://www.ah6le.net http://www.ah6le.com AH6LE/R - IRLP Node 300 http://www.irlp.net RC Websites http://oregonbarnstormers.rcclubs.com http://pegasus.rcplanet.com - 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: Mysql newbie
My problem is resolved. Apparently I was missing a package php-mysql. Funny, no docs I found make mention of this. In any case, I'm up and running. Thanks to all who offered help! Ken -- President - Arcom Communications Amateur Radio Station AH6LE Curious about the weather in Orygun? Check out http://www.ah6le.net/weather.html http://www.ah6le.net http://www.ah6le.com AH6LE/R - IRLP Node 300 http://www.irlp.net RC Websites http://oregonbarnstormers.rcclubs.com http://pegasus.rcplanet.com - 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: Mysql newbie
On Tue, 2002-11-05 at 11:21, Ken Arck wrote: I'm confused John. Since --with-mysql=shared,/usr' appears in the Configure Command table from phpinfo(), doesn't that mean php *was* compiled with mysql support? Yes it was compiled with mysql support through tje dbx commands look at the manual for PHP condcerning dbx. My copy says it's experimental. I suggest looking at php.net for some online documentation concerning dbx. At 12:03 AM 11/5/2002 -0500, John Coder wrote: On Mon, 2002-11-04 at 23:51, Ken Arck wrote: then it's compiled under dbx functions not mysql functions run configure again with the same arguments except for mysql just run --with-mysql and it should be ok. -As I said, it was installed from an rpm as part of the Redhat install package and not from a tarball. Are you saying to reinstall from a tarball after running configure? Either complile it from a tarball or get the src.rpm go in change the neccessary file in the src.rpm and compile it. ( which file I don't know). I personally know of no way to change your configure options without running make and make install. - 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 -- President - Arcom Communications Amateur Radio Station AH6LE Curious about the weather in Orygun? Check out http://www.ah6le.net/weather.html http://www.ah6le.net http://www.ah6le.com AH6LE/R - IRLP Node 300 http://www.irlp.net RC Websites http://oregonbarnstormers.rcclubs.com http://pegasus.rcplanet.com - 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: Mysql newbie
On Mon, 2002-11-04 at 21:51, Ken Arck wrote: Hi folks. I'm a real newbie to mysql (believe it or not!) While just starting to get my feet wet in it, I've come across a huge stumbling block already. I am familiar with php however. A php script I'm playing with has this line: $db = mysql_connect(localhost, root); Here's the html output Fatal error: Call to undefined function: mysql_connect() in /var/www/test.php on line 15 I even tried the updated command line with the same failed result $db = mysql_real_connect(localhost, root); BTW, doing a phpinfo() shows that mysql is compiled into php (I'm using PHP Version 4.1.2 ) Any help would be appreciated. Ken What exactly do you mean by compiled in ? what does your phpinfo say. You should have a section on mysql not just the line supported databases mysql,pgsql,etc. Here's what mine says mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.0.3-beta MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/mysql/include MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient Directive Local Value Master Value mysql.allow_persistent On On mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket no value no value mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited Hope thois helps - 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: Mysql newbie
At 10:32 PM 11/4/2002 -0500, you wrote: What exactly do you mean by compiled in ? what does your phpinfo say. You should have a section on mysql not just the line supported databases mysql,pgsql,etc. it reports mysql in two places: In the Configure Command table: --with-mysql=shared,/usr and under the dbx table: supported databases MySQLbr /ODBCbr /PostgreSQLbr /Microsoft SQL Serverbr /FrontBase (interesting it displays the html break codes). Apache, Mysql and php were all installed from the default Redhat 7.3 distro, with current updates for each package since the original install. Ken -- President - Arcom Communications Amateur Radio Station AH6LE Curious about the weather in Orygun? Check out http://www.ah6le.net/weather.html http://www.ah6le.net http://www.ah6le.com AH6LE/R - IRLP Node 300 http://www.irlp.net RC Websites http://oregonbarnstormers.rcclubs.com http://pegasus.rcplanet.com - 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: Mysql newbie
On Mon, 2002-11-04 at 23:20, Ken Arck wrote: At 10:32 PM 11/4/2002 -0500, you wrote: What exactly do you mean by compiled in ? what does your phpinfo say. You should have a section on mysql not just the line supported databases mysql,pgsql,etc. it reports mysql in two places: In the Configure Command table: --with-mysql=shared,/usr and under the dbx table: supported databases MySQLbr /ODBCbr /PostgreSQLbr /Microsoft SQL Serverbr /FrontBase then it's compiled under dbx functions not mysql functions run configure again with the same arguments except for mysql just run --with-mysql and it should be ok. John - 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: Mysql newbie
then it's compiled under dbx functions not mysql functions run configure again with the same arguments except for mysql just run --with-mysql and it should be ok. -As I said, it was installed from an rpm as part of the Redhat install package and not from a tarball. Are you saying to reinstall from a tarball after running configure? Ken -- President - Arcom Communications Amateur Radio Station AH6LE Curious about the weather in Orygun? Check out http://www.ah6le.net/weather.html http://www.ah6le.net http://www.ah6le.com AH6LE/R - IRLP Node 300 http://www.irlp.net RC Websites http://oregonbarnstormers.rcclubs.com http://pegasus.rcplanet.com - 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: Mysql newbie
On Mon, 2002-11-04 at 23:51, Ken Arck wrote: then it's compiled under dbx functions not mysql functions run configure again with the same arguments except for mysql just run --with-mysql and it should be ok. -As I said, it was installed from an rpm as part of the Redhat install package and not from a tarball. Are you saying to reinstall from a tarball after running configure? Either complile it from a tarball or get the src.rpm go in change the neccessary file in the src.rpm and compile it. ( which file I don't know). I personally know of no way to change your configure options without running make and make install. - 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: MYSQL newbie :-)
On Mon, 28 Oct 2002 [EMAIL PROTECTED] wrote: This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works Hi! See www.mysql.com/doc There is a tutorial section in the manual, it's not a big one, but you should be able to get started with it. The reference manual is excellent for further learning, too. Paul DuBois's book 'MySQL' is also very good. Also, searching Google with these 'mysql tutorial' will help... :-) Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: MYSQL newbie :-)
This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works After much confused reading, browsing and trial/error that didn't really get me anywhere I arrived here http://sqlcourse.com/ and http://sqlcourse2.com/ and was up to speed (relatively speaking ofcourse.. :-) in no time (an afternoon maybe?) They have an online SQL parser and sample tables that work from a webform where you can try the exercises they have after each short chapter. Regards, Martin -- mailto:mac.com;nemo http://www.mechintosh.com/ - 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: MYSQL newbie :-)
the manual is a very good place to start , its very organized , and its complete reference , better than any book . trial and error is good , but try to get a graphical user interface beter than the shell . there are many . --- [EMAIL PROTECTED] wrote: This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works Regards Liam - 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 _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP more! http://www.everyone.net/selectmail?campaign=tag - 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: MySQL newbie installation question
CM Miller wrote: Very new to MySQL and I've done a search on google.com, but really couldn't find the answer that I am looking for. Where should I install MySQL? I'm running RH 7.3 and I've installed the tgz file under my directory /home/CMMiller, is this right, or anywhere else? I see it is also under /usr/share. Do as the readme says - unpack the distribution and follow instructions. Standard location for mysql distribution is /usr/local/mysql from which you should make symlinks to /usr/loca/bin etc. You can put your data files pretty much everywhere but be very careful about permissions (some directories should be wriable by root only, some has to be writable by mysql user - read error nessages if in doubt and pay attention to security issues). Test your setup by starting the daemon manually specifying installation directory, data directory and user (-u mysql). Then put a service file in /etc/init.d and make symlinks to appropriate /etc/rc.d directories. how do I login once I get it up and going, or change passwords, or do basic admin work? There is a text client called 'mysql' :-) Check it out. HTH, Max - 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: mysql newbie
* Mylin Campos I'm a newbie with mysql. I have a few question and would really appreciate it if you can help me. I'm creating a database for a payroll system. I actually finish with my entity relationship diagram. What should be the next step? I know I should create the database already but while reading the mysql documentation I've been encountering so many questions that I'm getting all confused on where to start. First, where does the priviledges come in? Specifically the alter, drop, select, insert (etc) priviledges come in? This depends on the requirements of the system you are making. If the system will have users with different roles, you can create different users in mysql with different privileges. I normally use only one mysql user, with all privileges, and then create a separate user subsystem within my application. All 'users' are accessing the database with the same priveleged mysql user account, and it is up to my application to differentiate between the individual users of the system. This is all fine when the mysql database is hidden behind an application, but if you need to give users direct access to the database (using the mysql client or phpadmin or similar), the lack of security might be a problem. If you need security on the database level, use the privilege system and create separate users for all the database user roles you can define, and then GRANT privileges to each role for each column in each table. If you can handle security on the application level, use a single privileged mysql user. (This is not The Only Way, it's just how I do it. YMMV.) Or does this concern the database administrator which is not my concern since I'm only the software developer. It depends. You should consult with your DBA. Should I create the tables and then what next? yes. It's easy to change them later, if you change your mind about something. Mysql does not a have a feature like access where you link one key to another by dragging one field to another. does this mean that linking the tables in mysql is done manually via the sql statements? That is correct, no special definition is needed. Thanks for the advice. You're welcome! :) -- Roger - 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: mysql newbie
Hello, sorry for a late answer, but here it comes. On Tue, 27 Aug 2002, Mylin Campos wrote: I'm a newbie with mysql. I have a few question and would really appreciate it if you can help me. I'm creating a database for a payroll system. I actually finish with my entity relationship diagram. What should be the next step? I know I should create the database already but while reading the mysql documentation I've been encountering so many questions that I'm getting all confused on where to start. Right, if you have the root account or any other account that has enough privileges, the right way to start is to create your own database. For now stick with the default settings for that, they are OK. First, where does the priviledges come in? Specifically the alter, drop, select, insert (etc) priviledges come in? Or does this concern the database administrator which is not my concern since I'm only the software developer. Every time you run a query on MySQL it checks whether you have enough permissions to do so or not. If not, it returns an error. If you are the owner of your database (I suppose you are), you have all rights to that database, including ALTER, DROP, CREATE and so on. As the owner you also have SELECT, INSERT, UPDATE, DELETE at your disposal, along with others. If you read the manual beginner's section very carefully, I think you will grasp the permissions topic fairly well. It's important to remember that users are defined using username/hostname pairs. That is, for example, you can have different privileges, depending on whether you login from your work computer or your home computer, as they have different IP addresses and host names. Should I create the tables and then what next? Yep, create tables. Then insert/dump your data into them. Or do anything that suits your needs. :-) Mysql does not a have a feature like access where you link one key to another by dragging one field to another. does this mean that linking the tables in mysql is done manually via the sql statements? That's because MySQL is just a database backend, Access has the Jet engine that it uses as a separate DLL, MySQL clients are available but their current functionality is a bit limited in some cases. MySQLFront is a good one to start with. You can use Access, too, to use MySQL but all its graphical features won't work, though. phpMyAdmin is fairly efficient, but it requires you to have a web server running PHP. For most of your daily work you can use any graphical frontend you want to, but for the more advanced (mostly administrative) tasks you will want to learn enough pure SQL to accomplish those tasks more effectively. A URL for graphical MySQL frontends: http://www.mysql.com/downloads/gui-clients.html MyCC is pretty OK, but its development is still underway. Hope this helps, feel free to ask further questions as needed. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: mysql newbie
Mylin, Tuesday, August 27, 2002, 8:17:13 AM, you wrote: MC I'm a newbie with mysql. I have a few question and would really appreciate MC it if you can help me. I'm creating a database for a payroll system. I MC actually finish with my entity relationship diagram. What should be the MC next step? I know I should create the database already but while reading the MC mysql documentation I've been encountering so many questions that I'm MC getting all confused on where to start. MC First, where does the priviledges come in? Specifically the alter, drop, MC select, insert (etc) priviledges come in? Or does this concern the database MC administrator which is not my concern since I'm only the software developer. Look into database 'mysql'. It contains privilege tables. Description of tables you can find here: http://www.mysql.com/doc/en/Privileges.html Privileges for user could be granted on different levels: global, database, table, column. You can set up privileges using GRANT statement: http://www.mysql.com/doc/en/GRANT.html MC Mysql does not a have a feature like access where you link one key to MC another by dragging one field to another. does this mean that linking the MC tables in mysql is done manually via the sql statements? Yes. If you want to use more than one table you can do it like SELECT * FROM table1,table2 WHERE table1.id=table2.id http://www.mysql.com/doc/en/Multiple_tables.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Mysql newbie show table question
* marc malacarme I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like user_access; Does no work. The manual is your friend: URL: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html Syntax: SHOW TABLE STATUS [FROM db_name] [LIKE wild] In other words: remove where name from your query. -- Roger - 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: Mysql newbie show table question
Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme [EMAIL PROTECTED] wrote: I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like user_access; Does no work. Thank You - 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: Mysql newbie show table question
marc, Friday, May 31, 2002, 6:39:54 PM, you wrote: mm I can¹t seem to make any of the describe or show queries work when I apply a mm search statement: mm Query=show table status from demo; mm Works fine. Now I¹m trying to get info from only one table: mm Query=show table status from demo where name like user_access; mm Does no work. Use correct syntax for SHOW TABLE STATUS statement: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html mm Thank You -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Mysql newbie show table question
Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme [EMAIL PROTECTED] wrote: I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like user_access; Does no work. Thank You - 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: MySQL newbie question
did you start mysqld ? -Original Message- From: David Burklin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:36 PM To: '[EMAIL PROTECTED]' Subject: MySQL newbie question Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. - 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
RE: MySQL newbie question
yes... at least I thought so, although I think I may not have started it properly. I have set it to an on state, using chkconfig --level 2345 mysqld on. Afterwhich, if I do a chkconfig --list mysqld, it reports that mysqld is running. However, I have found reference to using the command mysql.server start in the online help manual. When I run that, I get [root@Acillatem mysql]# ./mysql.server start [root@Acillatem mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020115 13:38:41 mysqld ended I think I've missed something somewhere... a ps -ax does not report the daemon running, so that's the big part of my problem. -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:44 PM To: David Burklin; '[EMAIL PROTECTED]' Subject: RE: MySQL newbie question did you start mysqld ? -Original Message- From: David Burklin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:36 PM To: '[EMAIL PROTECTED]' Subject: MySQL newbie question Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. - 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
Re: MySQL newbie question
On Wednesday 16 Jan 2002 7:36 pm, you wrote: Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. type ps -A | grep mysql to see if mysql is running. If its not then try /etc/init.d/mysqld start to see if there are any error messages. If it just wasn't started when you booted type ntsys and scroll down the menu until you reach mysqld and hit space which should put a little star by it and therfore get it working - 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: MySQL newbie question
This did the trick. Thanks Nod and everyone else! -Original Message- From: nod [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:02 PM To: David Burklin Cc: [EMAIL PROTECTED] Subject: Re: MySQL newbie question On Wednesday 16 Jan 2002 7:36 pm, you wrote: Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. type ps -A | grep mysql to see if mysql is running. If its not then try /etc/init.d/mysqld start to see if there are any error messages. If it just wasn't started when you booted type ntsys and scroll down the menu until you reach mysqld and hit space which should put a little star by it and therfore get it working - 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: MySQL Newbie and Access Database
Hi Jose, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Gerardo Amaya Giron Sent: Thursday, November 22, 2001 1:11 PM To: [EMAIL PROTECTED] Subject: MySQL Newbie and Access Database Hello all, I just start up with mysql so I have some stupid questions to ask. right now I have an MS Access database with one table that has 25 fields and like 2000 records in it. I'm trying to move to MySQL in order to have a better DB. I can define the database and the table manually that's not a problem, My problem is how can I export the 2000+ records from the Access DB to MySQL DB. does an export file from access do the job??? I read a little bit about myODBC, does myODBC help me in this situation, does it help me export all the records to the new database??? Yes. You can make use of MyODBC to export tables and/or associted data from MS Access to MySQL. Here is the snippet from new MyODBC manual on how to export data from MS Access to MySQL. Q. Export a table or query to MySQL using MyODBC data source Note: You can only export a table or query to MySQL server, if you have installed the latest MyODBC driver 2.50.38 or grater, else you will experince problems with text and varchar data types. 1. In the Database window (The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click the name of the table or query you want to export, and then on the File menu, click Export. 2. In the Export Object Type 'Object name' To dialog box, in the Save As Type box, click ODBC Databases (). 3. In the Export dialog box, enter a name for the file (or use the suggested name), and then click OK. The Select Data Source dialog box is displayed; it lists the defined data sources for any ODBC drivers installed on your computer. 4. Click either the File Data Source or Machine Data Source tab, and then double-click the MyODBC data source that you want to export to To define a new data source for MyODBC driver, please follow the instructions from: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#Installi ng_MyODBC 5. Microsoft Access connects to the MySQL server through MyODBC data source and creates the new table in the server. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - 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: mySQL newbie?
Hi, Is their another gui I could use to populate a mySQL database? my personal opinion - the best MySQL GUI by far I've seen is the EMS MyManager: http://ems-hitech.com/mymanager/ Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - 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: MySQL Newbie install question
TCPwrappers has nothing to do with mysql. Mysqld manages the port itself. You do not want tcpwrappers grabbing the port. Check the path to mysql.sock. It must be world searchable and readable for the client to write to the socket. Read the section of the manual on GRANT privileges. You are not root. Unless you specify -u root, you can't do anything. There are no users that can access the server until you set them up. Damian Moran wrote: Hi I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box. When I try to contact the mysql server i get the following error: [someone@somemachine ~]$ mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! /var/lib/mysql/mysql.sock exists. My syslog doesnt log anything from MySql. Port 3306 is free and the DB answers when I telnet to the port but reports the error below: IHost 'somehost.com' is not allowed to connect to this MySQL serverConnection closed by foreign host. I am using tcpwrappers but local host (and somehost.com) has been added to hosts.allow. Any and all ideas as to what I am doing wrong or missing greatly appreciated! Thanks, Damian - 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