Re: San Diego mySQL usergroup
Rick, I will be glad to join you Nestor :-) -Original Message- From: Rick Schulze [EMAIL PROTECTED] Sent: Sep 8, 2005 1:21 PM To: mysql@lists.mysql.com Subject: San Diego mySQL usergroup I would like to form a San Diego mySQL user group, I notice we don't have one down here that I can see. I do not want to take the burden of putting the group together but I do have the building, large meeting room, access at night/evening, PA system if needed, projectors if needed etc. I am completely self motivated here. I have made the decision to take some of our applications off of Oracle and onto mySQL for various reasons and I want somewhere that my staff and myself can go to listen, learn and interact with mySQL. If someone is interested in actually putting together the usergroup and hosting it here, let me know and we'll get things rolling. Richard Schulze Director of Information Technology Kontron America 14118 Stowe Drive Poway, CA 92064 tel: 858.677.0877 fax: 858.677.0895 cell: 858.405.3092 [EMAIL PROTECTED] www.kontron.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database equivalent to NorthWind for M$ SQL
Can you also sent it to me. Thanks! Nesto r:-) -Original Message- From: J. David Boyd [EMAIL PROTECTED] Sent: Aug 2, 2005 8:20 AM To: mysql@lists.mysql.com Subject: Re: Database equivalent to NorthWind for M$ SQL Peter Brawley [EMAIL PROTECTED] writes: Scott, Is there any database file similiar to M$'s Northwind that I can use to play with? It would be nice if there is one inside MySQL by default for newbies to start out with. For our chapters on Connector/ODBC and dotNet, Arthur I wrote scripts to create MySQL versions of the NW schema ... http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html (InnoDB) and http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html#11-2 (MyISAM). If you like, I'll email you the SQL script for populating the tables. PB I would like to see these scripts as well. Can you please post them somewhere, or mail them to me as well? Dave -- 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]
Report tools
Any report tools that can be use with Mysql that you guys can recommend? Any free mysql report generators? Thanks, Nestor :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: just hi
Ezequiel, Tambien hay una lista de mysql en Espagnol. :-) -Original Message- From: Johan H��k [EMAIL PROTECTED] Sent: May 11, 2005 4:35 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: just hi Hi Ezequiel, see: http://dev.mysql.com/doc/ /Johan Ezequiel Rodriguez wrote: well im from argentina, and today i begin using mysql, i have a lot of questions, first of all, is there a mysql official manual at www.mysql.com? i have searched but don't found it :S I want to read something before ask thnx :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
backing up Databases in Mysql
TO back up the databases in Mysql, isn't there a way where you can just copy somefiles to another directory and in essence you have a backup? I thought I read this somewhere No I can do a dump, but I was wondering if I can just copy some lies or a directory. Thanks, Néstor Alberto Flórez Torres -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Passing single quote within a query
Hello world, I am passing a a string Joe's car as part of the SQL query to be inserted to a String field. $field=Joe's car; $query=insert into mytable values('$field'); Do you generally change the quote to a double quote before inserting or what is the recomended way, because otherwise the quote will terminate the query statement. Thanks, :-) Néstor Alberto Flórez Torres -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql and PHP
OS is W2K. -Original Message- From: nestor(earth) [EMAIL PROTECTED] Sent: Sep 15, 2004 8:04 AM To: Cc: [EMAIL PROTECTED] Subject: Mysql and PHP People, This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as of last night) and it runs. My problem is that PHP does not see Mysql. Now I have done this installation 4 or 5 times but th elast time was over a year ago. Any ideas? Thanks! Nestor :-) http://www.IneedWork.org -- 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]
How do I find out a table's constraints ?
What command should I use to find out a table's constraints? Thanks, :-) Néstor Alberto Flórez Torres -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: interesting....BUG?
Victoria, The seleect statements that I wrote is what I use. And if there was a limit should the limit be used in both o f my select? Database changed mysql SELECT @@session.sql_select_limit; ++ | @@session.sql_select_limit | ++ | 4294967295 | ++ 1 row in set (0.02 sec) *- Rhino, I enter the command manually from Myusql after I have changed databases ( use database) and the answers where different. I catell you that show tables only shows : mysql show tables; +-+ | Tables_in_ecrop | +-+ | course_eng | | course_esp | +-+ I have it working by switching all my commands to access Course_Eng but I was just wondering about this. Thanks for your help :-) Nestor :-) Néstor A. Flórez Victoria Reznichenko [EMAIL PROTECTED] 3/22/2004 2:06:55 AM Nestor Florez [EMAIL PROTECTED] wrote: I have a php web application that has an admin page for inserting course = records and one for selecting course records=20 and a client page for selecting course record. =20 In the admin side I insert records with an insert into Course_Eng and I = select records witha select * from Course_Eng In the client side I get records witha select * from course_eng The kicker is that my client webbased select will only return 40 records = (no limits are being use) but my admin webbased select returns 200 records. I SSH into the server and when I = check the table desc course_eng look good. After scraching my head several times I found out that if manually typed = on the server my select statement as select * from Course_Eng I would get 200 records = back, but if I typed select * from course_eng I would get 40 records. Is this a bug? or a feature? Whe I did a show tables;, the table name is course_eng ther was no = table Course_Eng If I remember correct in the SQL syntax the case should not matter? I change all my inserts and selects to Course_Eng that seem to work and = returned me the most records My server is a Mac OS 10.2 and the Mysql version is server version: = 4.0.16 SELECT * FROM course_eng is the exact query that you use? Check with SELECT @@session.sql_select_limit that it's not SQL_SELECT_LIMIT issue. -- 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 -- 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]
interesting....BUG?
People, I have a php web application that has an admin page for inserting course records and one for selecting course records and a client page for selecting course record. In the admin side I insert records with an insert into Course_Eng and I select records witha select * from Course_Eng In the client side I get records witha select * from course_eng The kicker is that my client webbased select will only return 40 records (no limits are being use) but my admin webbased select returns 200 records. I SSH into the server and when I check the table desc course_eng look good. After scraching my head several times I found out that if manually typed on the server my select statement as select * from Course_Eng I would get 200 records back, but if I typed select * from course_eng I would get 40 records. Is this a bug? or a feature? Whe I did a show tables;, the table name is course_eng ther was no table Course_Eng If I remember correct in the SQL syntax the case should not matter? I change all my inserts and selects to Course_Eng that seem to work and returned me the most records My server is a Mac OS 10.2 and the Mysql version is server version: 4.0.16 Any ideas? thanks, Nestor :-) Néstor A. Flórez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: import data from text files
Armin, 1)When you say that the records are duplicate, do you mean the record number(first field) or or do you mean the entire record is a duplicate? 2)Now to load a file made out of comma separated fields into a table that was created in the same field format, here are 2 ways: a)mysql USE db1; mysql LOAD DATA INFILE data.txt INTO TABLE db2.my_table; b)C:\ mysql databasename filename (You just got to make sure that the beginning of the file has the insert statement in it ) GOdd Luck, Nestor :-) -Original Message- From: Armin [EMAIL PROTECTED] Sent: Jan 9, 2004 6:16 PM To: [EMAIL PROTECTED] Subject: import data from text files hi list , I've got two problem with mysql , maybe it is not a real 'problem' but i need help hardly ! :) 1 in a table , we got many record ( 1400 ) , some of them are equal , i want to delete just one of them , in other word , i don't want two record equal . 2 i got a text file , which must be into a table , text file syntax is ' a,b,c ' and in table we got ' id,user,pass ' , how can i load data from text into right place on table ? for example i got this in text file ( text file is long , 4200 line ) : 1,zoup,mypass which must be in table as id|user|password 1 zoup mypass it is radcheck table (radius) , thanks in advanced :) -- If you put garbage in a computer nothing comes out but garbage. But this garbage, having passed through a very expensive machine, is somehow enabled and none dare criticize it. -- 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]
Grant permissions problems - help
I have a mysql db where via a web page I access a database I have set the permissions to grant select, insert, update, delete on test.* to [EMAIL PROTECTED] identified by 'nestor'; flush privileges; The database has 3 tables. I can select via PHP code all the tables, but when I try to insert or update 2 of the tables allow me but there is one table that does not. My schools table refuses to insert or update, but my courses_eng and course_esp allows me to select, insert, update, delete I them gave the following command: grant all privileges on test.* to [EMAIL PROTECTED] identified by 'nestor'; grant all privileges on test.* to nestor@'%' identified by 'nestor'; flush privileges; I am still not able to insert and update to the school table, but I can do this on the course_eng and course_esp tables. Any ideas. Thanks, Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Grant permissions problems - help
I forgot to mentioned that this same code works on the same database on my W2K but I am having problems on my Mac OS X (Darwin). I sqldump the database from my W2K to my Mac Os X. Nestor :-) Nestor A. Florez Nestor Florez 11/13/2003 10:17:37 AM I have a mysql db where via a web page I access a database I have set the permissions to grant select, insert, update, delete on test.* to [EMAIL PROTECTED] identified by 'nestor'; flush privileges; The database has 3 tables. I can select via PHP code all the tables, but when I try to insert or update 2 of the tables allow me but there is one table that does not. My schools table refuses to insert or update, but my courses_eng and course_esp allows me to select, insert, update, delete I them gave the following command: grant all privileges on test.* to [EMAIL PROTECTED] identified by 'nestor'; grant all privileges on test.* to nestor@'%' identified by 'nestor'; flush privileges; I am still not able to insert and update to the school table, but I can do this on the course_eng and course_esp tables. Any ideas. Thanks, Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Grant permissions problems - help
+-+ | Grants for [EMAIL PROTECTED] | +-+ | GRANT USAGE ON *.* TO 'nestor'@'%' IDENTIFIED BY PASSWORD '93c8c803300d29b9' | | GRANT ALL PRIVILEGES ON `test`.* TO 'nestor'@'%' | +-+ IS the same on both my W2K and my Mac OS X Nestor :-) Nestor A. Florez Victor Pendleton [EMAIL PROTECTED] 11/13/2003 11:01:37 AM execute show grants for nestor@'%' and see what that user has. -Original Message- I forgot to mentioned that this same code works on the same database on my W2K but I am having problems on my Mac OS X (Darwin). I sqldump the database from my W2K to my Mac Os X. Nestor :-) Nestor A. Florez Nestor Florez 11/13/2003 10:17:37 AM I have a mysql db where via a web page I access a database I have set the permissions to grant select, insert, update, delete on test.* to [EMAIL PROTECTED] identified by 'nestor'; flush privileges; The database has 3 tables. I can select via PHP code all the tables, but when I try to insert or update 2 of the tables allow me but there is one table that does not. My schools table refuses to insert or update, but my courses_eng and course_esp allows me to select, insert, update, delete I them gave the following command: grant all privileges on test.* to [EMAIL PROTECTED] identified by 'nestor'; grant all privileges on test.* to nestor@'%' identified by 'nestor'; flush privileges; I am still not able to insert and update to the school table, but I can do this on the course_eng and course_esp tables. Any ideas. Thanks, Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Grant permissions problems - help
I just realized that if I login to mysql as the user I can insert records. It must be somehting with my code I will try the trace_on It is just amazing that the same code works in my W2K machine and when I ftp it to the Mac OS X only adding to th eschools fails. Thanks, Nestor :-) Nestor A. Florez George Webb [EMAIL PROTECTED] 11/13/2003 11:06:29 AM Hi Nestor. What does the mysql_error() report as the exact error message? This could help you identify what kind of access control issue it is. Alternatively, you could try running the same query from the command line (using the mysql client) and see if you get the same error. Also, I'm not really sure about this feature, but it has helped me once or twice: trace mode. In PHP, you can do ini_set('mysql.trace_mode','on'); and there might be a way to do this also with the mysql client Best, George. George Webb [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Grant permissions problems - help
OK guys this is beyond me. I just found out that I can NOT insert into my SCHOOL table when I login into mysql as user nestor on my Mac OS X. The table is autoincremented. how do I find out what is the next number to be incremented? Nestor :-) Nestor A. Florez Nestor Florez [EMAIL PROTECTED] 11/13/2003 11:08:58 AM I just realized that if I login to mysql as the user I can insert records. It must be somehting with my code I will try the trace_on It is just amazing that the same code works in my W2K machine and when I ftp it to the Mac OS X only adding to th eschools fails. Thanks, Nestor :-) Nestor A. Florez George Webb [EMAIL PROTECTED] 11/13/2003 11:06:29 AM Hi Nestor. What does the mysql_error() report as the exact error message? This could help you identify what kind of access control issue it is. Alternatively, you could try running the same query from the command line (using the mysql client) and see if you get the same error. Also, I'm not really sure about this feature, but it has helped me once or twice: trace mode. In PHP, you can do ini_set('mysql.trace_mode','on'); and there might be a way to do this also with the mysql client Best, George. George Webb [EMAIL PROTECTED] -- 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: Grant permissions problems - help
Victor, I will fixed this, but I do not think this is th eproblem. I have the same settings on both W2K and Mac OS X and it only fails on the Mac Also When I log in as nestor with a password on the Mac I can not insert a record from the ocmmand line. I can do this on my W2K database. Thanks I will try it, Nestor :-) Nestor A. Florez Victor Pendleton [EMAIL PROTECTED] 11/13/2003 11:49:51 AM Their are two nestor users. One with a password and one without a password. The one with connect from anywhere is only allowed to modify the test database. Fix your privileges and you should be okay. -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Grant permissions problems - help +--- --+ | Grants for [EMAIL PROTECTED] | +--- --+ | GRANT USAGE ON *.* TO 'nestor'@'%' IDENTIFIED BY PASSWORD '93c8c803300d29b9' | | GRANT ALL PRIVILEGES ON `test`.* TO 'nestor'@'%' | +--- --+ IS the same on both my W2K and my Mac OS X Nestor :-) Nestor A. Florez Victor Pendleton [EMAIL PROTECTED] 11/13/2003 11:01:37 AM execute show grants for nestor@'%' and see what that user has. -Original Message- I forgot to mentioned that this same code works on the same database on my W2K but I am having problems on my Mac OS X (Darwin). I sqldump the database from my W2K to my Mac Os X. Nestor :-) Nestor A. Florez Nestor Florez 11/13/2003 10:17:37 AM I have a mysql db where via a web page I access a database I have set the permissions to grant select, insert, update, delete on test.* to [EMAIL PROTECTED] identified by 'nestor'; flush privileges; The database has 3 tables. I can select via PHP code all the tables, but when I try to insert or update 2 of the tables allow me but there is one table that does not. My schools table refuses to insert or update, but my courses_eng and course_esp allows me to select, insert, update, delete I them gave the following command: grant all privileges on test.* to [EMAIL PROTECTED] identified by 'nestor'; grant all privileges on test.* to nestor@'%' identified by 'nestor'; flush privileges; I am still not able to insert and update to the school table, but I can do this on the course_eng and course_esp tables. Any ideas. Thanks, Nestor :-) Nestor A. Florez -- 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: Grant permissions problems - help
I actually took a look at the mysql.user table and user nestor has a password in both entries to the table. One entry is for localhost and the other is for '%'; I try inserting from the command line and I get: mysql insert into School (school_desc) values ('Nestor'); Query OK, 1 row affected (0.00 sec) Even when I do it as the main root for mysql the record is not inserted. Do you know how to reset the auto_increment Nestor :-) Nestor A. Florez Victor Pendleton [EMAIL PROTECTED] 11/13/2003 11:49:51 AM Their are two nestor users. One with a password and one without a password. The one with connect from anywhere is only allowed to modify the test database. Fix your privileges and you should be okay. -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Grant permissions problems - help +--- --+ | Grants for [EMAIL PROTECTED] | +--- --+ | GRANT USAGE ON *.* TO 'nestor'@'%' IDENTIFIED BY PASSWORD '93c8c803300d29b9' | | GRANT ALL PRIVILEGES ON `test`.* TO 'nestor'@'%' | +--- --+ IS the same on both my W2K and my Mac OS X Nestor :-) Nestor A. Florez Victor Pendleton [EMAIL PROTECTED] 11/13/2003 11:01:37 AM execute show grants for nestor@'%' and see what that user has. -Original Message- I forgot to mentioned that this same code works on the same database on my W2K but I am having problems on my Mac OS X (Darwin). I sqldump the database from my W2K to my Mac Os X. Nestor :-) Nestor A. Florez Nestor Florez 11/13/2003 10:17:37 AM I have a mysql db where via a web page I access a database I have set the permissions to grant select, insert, update, delete on test.* to [EMAIL PROTECTED] identified by 'nestor'; flush privileges; The database has 3 tables. I can select via PHP code all the tables, but when I try to insert or update 2 of the tables allow me but there is one table that does not. My schools table refuses to insert or update, but my courses_eng and course_esp allows me to select, insert, update, delete I them gave the following command: grant all privileges on test.* to [EMAIL PROTECTED] identified by 'nestor'; grant all privileges on test.* to nestor@'%' identified by 'nestor'; flush privileges; I am still not able to insert and update to the school table, but I can do this on the course_eng and course_esp tables. Any ideas. Thanks, Nestor :-) Nestor A. Florez -- 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: Grant permissions problems - help - WORKS!
Thanks for the help to ALL I got it to work. I do not know how but I think that they might have been hidden characters in the program doing insert in the actuall insert statements. I retyped the insert code in the program and things started to work. Probably when I ftp the code somethin gelse got added. Thanks again, Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help comparing MySQL to MS SQL Server
I have not work with it but postgres is supposed to work great in /BSD/Linux/Unix/solaris environment Which platform are you using? :-) Nestor A. Florez Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM Hi Kevin, Martijn, thank you very much for your analysis. I hope others will continue to join in. So do I :-) With regard to your point quoted below, are you referring to PostgreSQL, and would that be a stronger competitor to MS SQL Server 2000 than either the current version of MySQL or MySQL 5? I have no experience with PostgreSQL - although, from what I've heard and read, it's quite capable - but not easy to get going on Windows. One other open source RDBMS would be Firebird - see www.firebirdsql.org Especially the newer release (1.5). Don't get fooled by that version number - it's a fork of the Borland InterBase code, which has been around for about 20 years now. I'm looking forward to MySQL5 to see what's new and how it's implemented. As for what engine would be the best for you - it all depends on what you're going to do. For example, I frequently use triggers and check constraints in my database applications, with MySQL, I can't do this. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56 /usr/libexec/mysqld: Shutdown Complete *--- Then I tried running *- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031106 07:23:11 mysqld ended *- I still get the error on the /var/mysql/'hostname.err' file *-- 031106 07:23:08 mysqld started 031106 7:23:09 InnoDB: Started 031106 7:23:09 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031106 7:23:09 Aborting 031106 7:23:09 InnoDB: Starting shutdown... 031106 7:23:11 InnoDB: Shutdown completed 031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete 031106 07:23:11 mysqld ended *-- Any other ideas? Thanks, :-) Nestor A. Florez Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM Are you using Panther client or server? my.cnf is usually in /etc. Have you run mysql_install_db yet? - Gabriel On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote: Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- 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 on panther
My OS X does not have my.cnf anywhere on the machine. :-) Nestor A. Florez Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM Are you using Panther client or server? my.cnf is usually in /etc. Have you run mysql_install_db yet? - Gabriel On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote: Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
Egor, Where is the datadir locate? :-) Nestor A. Florez Egor Egorov [EMAIL PROTECTED] 11/6/2003 7:40:28 AM Nestor Florez [EMAIL PROTECTED] wrote: I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56 /usr/libexec/mysqld: Shutdown Complete *--- Then I tried running=20 *- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031106 07:23:11 mysqld ended *- I still get the error on the /var/mysql/'hostname.err' file *-- 031106 07:23:08 mysqld started 031106 7:23:09 InnoDB: Started 031106 7:23:09 Fatal error: Can't open privilege tables: Can't find = file: './mysql/host.frm' (errno: 13) 031106 7:23:09 Aborting 031106 7:23:09 InnoDB: Starting shutdown... 031106 7:23:11 InnoDB: Shutdown completed 031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete 031106 07:23:11 mysqld ended *-- Any other ideas? perror 13 Error code 13: Permission denied MySQL should be owner of the data dir. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql on panther
Thanks to all the help...I got it working!!! Basically, as recommended, I created a my.cnf I also chown my /var/mysql directory to user 'mysql' and I am cooking now Thanks again!! Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql on panther
Hi guys, I just was given the OK to play with a new server running Mac OS X (Panther) When I give the command (it is recommended to use mysqld_safe instead of mysqld in some website) *--- # /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/mysql 031105 13:09:40 mysqld ended *--- I look at the .err file in /var/mysql/ and it looks like this: * 031105 13:09:38 mysqld started 031105 13:09:38 InnoDB: Started 031105 13:09:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031105 13:09:38 Aborting 031105 13:09:38 InnoDB: Starting shutdown... 031105 13:09:40 InnoDB: Shutdown completed 031105 13:09:40 /usr/libexec/mysqld: Shutdown Complete 031105 13:09:40 mysqld ended * I search for the my.cnf and I do not find it, but I know that Mac OS X puts things in different places. Any ideas? Thanks :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Command line fails mysql mydb mufile.sql
Help, Guys I have done this before but it is not working for me when I try to do some inserts via a file from the command line c:\mysql mydb myfile.sql ERROR 1044: Access denied for user: '@localhost' to database 'mydb' I am logged in as administrator on my W2K and I have granted ALL privileges to administrator and it fails: grant all privileges on mydb.* to [EMAIL PROTECTED] identified by 'pwd'; I even tried the following grants: grant all privileges on mydb.* to administrator@'%' identified by 'pwd'; grant all privileges on mydb.* to '%@'%' identified by 'pwd'; No luck here. Any ideas? Thanks, Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command line fails mysql mydb mufile.sql
Did not workd, I get an error ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I can log in as -u administrator when I use the -p option. I need to make it work from command line because I am planning to put this command in a script to make it automatic to insert records. Nestor :-) Nestor A. Florez Tobias Asplund [EMAIL PROTECTED] 10/15/2003 12:02:21 PM c:\mysql mydb myfile.sql ERROR 1044: Access denied for user: '@localhost' to database 'mydb' try mysql -u administrator mydb myfile.sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command line fails mysql mydb mufile.sql
Believe it or not I tried mysql -p administrator -p pwd mydb myfile.sql and it would not worked, but when I got rid of the space it work mysql -uadministrator -upwd mydb myfile.sql I did not think that the spaces after the '-u' and the '-p' matter Thanks, Nestor :-) Nestor A. Florez Victoria Reznichenko [EMAIL PROTECTED] 10/15/2003 12:28:24 PM Nestor Florez [EMAIL PROTECTED] wrote: Help, Guys I have done this before but it is not working for me when I try to do some inserts via a file from the command line c:\mysql mydb myfile.sql ERROR 1044: Access denied for user: '@localhost' to database 'mydb' I am logged in as administrator on my W2K and I have granted ALL privileges to administrator and it fails: grant all privileges on mydb.* to [EMAIL PROTECTED] identified by 'pwd'; I even tried the following grants: grant all privileges on mydb.* to administrator@'%' identified by 'pwd'; grant all privileges on mydb.* to '%@'%' identified by 'pwd'; No luck here. Any ideas? You forgot to specify user name and password. You can do something like: mysql -uadministrator -ppwd mydb myfile.sql -- 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 -- 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: RE: What's up with this GATOR crap?
Interesting! After reading about gator via this email I ran ad-aware on my laptop and it found gator. Could it be that one of these emails had it in it? No more gator on my machine C U later gator :-) ---Original Message--- From: _Chris McKeever_ [EMAIL PROTECTED] Sent: 07/11/03 06:09 AM To: 'Paul DuBois' [EMAIL PROTECTED], C. Reeve [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: What's up with this GATOR crap? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 10:59 PM To: C. Reeve; [EMAIL PROTECTED] Subject: Re: What's up with this GATOR crap? At 23:43 -0400 7/10/03, C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going to use spyware, I may have to consider using another database. This may sound extreme, but I do not condone the use of spyware in any form and would hope that others feel the same way. Comments Does anyone else here experience this? I _did_ experience this, but it was because gator creaped onto my system, and there is something on the mysql site that gets it all excited. Removing gator stopped it for me -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: What's up with this GATOR crap?
Nils, Why don't you chill dude. Go have an Ice cream or a beer. If you look at my email again, I said Could it be that one of these emails had it in it? I WAS JUST ASKING. That is permited, isn't it? And on top of that Nils, let me tell you that I never said anything about downloading Mysql. Last time I ran ad-aware was about a 2 weeks ago and I did not have the gator then. I am happy tha someone mentioned the gator and I removed it. There is no need for you to star a friendship in such a rude manner. Read my email again! It is Friday night, Nils go have a beer dude. Nestor :-( ---Original Message--- From: Nils Valentin [EMAIL PROTECTED] Sent: 07/11/03 06:34 PM To: Nestor Florez [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: What's up with this GATOR crap? Hi Nestor, excuse me for my words, but what you write is crap. MySQL does definitely NOT include any software like Gator etc. If Gator is on your PC than a person who is using your PC has knowingly or not installed it. Gator comes very often with some free software, but certainly not with MySQL. If there would be Gator etc. included in the e-mail than probably any of the 18.000 list subscribers would immediately ring the bell at MySQL AB. So think again, uninstall the rubbish on your PC and than you will realize hats this is not related to MySQL at all. Gator and other spyware has included mechanisms to place adds on your screens exactly referencing the topics of your interest (which they retrieve from your browsing behaviour). Best regards Nils Valentin Tokyo/Japan 2003??? 7??? 12??? ? 06:26???Nestor Florez : Interesting! After reading about gator via this email I ran ad-aware on my laptop and it found gator. Could it be that one of these emails had it in it? No more gator on my machine C U later gator :-) ---Original Message--- From: _Chris McKeever_ [EMAIL PROTECTED] Sent: 07/11/03 06:09 AM To: 'Paul DuBois' [EMAIL PROTECTED], C. Reeve [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: What's up with this GATOR crap? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 10:59 PM To: C. Reeve; [EMAIL PROTECTED] Subject: Re: What's up with this GATOR crap? At 23:43 -0400 7/10/03, C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going to use spyware, I may have to consider using another database. This may sound extreme, but I do not condone the use of spyware in any form and would hope that others feel the same way. Comments Does anyone else here experience this? I _did_ experience this, but it was because gator creaped onto my system, and there is something on the mysql site that gets it all excited. Removing gator stopped it for me -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- 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: Re: What's up with this GATOR crap?
I must have received via email somehow from someone. I get a lot of jokes from my Colombian newsgroup. I do not have any of those tools Kazaa or whatever. I only use my machines for email and AMP and LAMP copding. The last thing I installed on my laptop was mozilla the latest release. I am glad I read about it and I was just asking. No biggy is out of my life. Happy weekend to all :-) ---Original Message--- From: Ed Leafe [EMAIL PROTECTED] Sent: 07/11/03 06:24 PM To: Nestor Florez [EMAIL PROTECTED] Subject: Re: What's up with this GATOR crap? On Friday, July 11, 2003, at 05:26 PM, Nestor Florez wrote: After reading about gator via this email I ran ad-aware on my laptop and it found gator. Could it be that one of these emails had it in it? I got it when my son installed Kazaa. It seems Kazaa makes all their money by selling piggy-back installation to 3rd parties, many of which install spyware, and Gator is one of the most common. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000
I do not understand why people have to get hard on other people just because they ask a question. If you do not a helpful thing to say well do not reply. The reason why people ask is because there are looking for shortcuts that are known by those who have been around and it is great because you do not have to reinvent the wheel. Kira, Try searching on freshmeat.net They have tools that will actually install all of this software packages for you or you can do a search on google for PHP DREAMWEAVER MYSQL WINDOWS Have a good weekend people, :-) ---Original Message--- From: Ashley M. Kirchner [EMAIL PROTECTED] Sent: 04/04/03 09:04 AM To: [EMAIL PROTECTED] Subject: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000 [EMAIL PROTECTED] wrote: yes i know that. How? was my question. How...what? How to setup MySQL? How to setup PHP? How to read the manual? How to work your own computer? You ask vague questions, and can only expect vague answers back. and the manual have you seen how long that is? Yes, which is what makes it a good manual. There is a reason why they give you a Table of Contents right at the very beginning. It's less than 2 pages long and all you have to read is the Installation section. After that, you can read how to create your own databases. You're making this way harder than it really is. You think you have to read the whole manual, instead of reading the sections you need help with. when i looked under What is MySql? it says MySql is a powerful database tool blah blah. MySql can do this and this and this When you're trying to learn how to drive a car, what do you do? Ask first what a car is? I decided not to frustrate myself for 8 hours on this, No, instead you're asking someone else to chew your food for you, and have you swallow it. Like I said, if you took the time to even read the table of contents, you would've quickly found out which sections specifically you needed to read - it's very short and can be done within 10 minutes. -- H| I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6 a target=_blank href=http://www.pcraft.com;http://www.pcraft.com/a . . .. Boulder, CO 80303, U.S.A. -- MySQL General Mailing List For list archives: a target=_blank href=http://lists.mysql.com/mysql;http://lists.mysql.com/mysql/a To unsubscribe:a target=_blank href=http://lists.mysql.com/[EMAIL PROTECTED]http://lists.mysql.com/[EMAIL PROTECTED]/a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connecting from web server to a MySQL server using Apache+PHP
People, I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3) I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2) My connecting string is mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd); And I ge the error: Warning: Can't connect to MySQL server on '66.161.11.215' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Warning: MySQL Connection Failed: Can't connect to MySQL server on '66.161.11.215' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Can't connect to MySQL server on '66.161.11.215' (111) Line 36 is where mymysql_connect function is at. Any ideas? Nestor :-) - 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
REVISED: Connecting from web server to a MySQL server using Apache+PHP
People, I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3) I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2) My connecting string is mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd); And I ge the error: Warning: Can't connect to MySQL server on '10.1.1.3' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Warning: MySQL Connection Failed: Can't connect to MySQL server on '10.1.1.3' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Can't connect to MySQL server on '66.161.11.215' (111) Line 36 is where mymysql_connect function is at. Any ideas? Nestor :-) - 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
REVISED: Connecting from web server to a MySQL server using Apache+PHP
I messed up in the ip addressing sorry! -- People, I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3) I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2) My connecting string is mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd); And I ge the error: Warning: Can't connect to MySQL server on '10.1.1.3' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Warning: MySQL Connection Failed: Can't connect to MySQL server on '10.1.1.3' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Can't connect to MySQL server on '10.1.1.3' (111) Line 36 is where mymysql_connect function is at. Any ideas? Nestor :-) - 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
FW: REVISED: Connecting from web server to a MySQL server using Apache+PHP
OK now I am getting this error: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I look at the db table of mysql and [EMAIL PROTECTED] has select and insert permissions on the table that I am trying to connect Nestor :-) - 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 on SQLyog
Check the db table in mysql database. See what that says also, I notice the error was that kevin.smith.com not allowed sould that be [EMAIL PROTECTED] not allowed? Generally you will get kevin@localhost not allowed. Grant priviledges to that user on that machine as [EMAIL PROTECTED] Nestor :-) -Original Message- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:53 AM To: Nestor Florez Cc: [EMAIL PROTECTED] Subject: RE: Help on SQLyog Nestor: I've set the password for root and granted privileges to it. see below: mysql select * from user where user='root'; +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | localhost | root | 005a1506376eec48 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | stargate | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ 2 rows in set (0.04 sec) --Kevin -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:32 AM To: Kevin Tsay Subject: RE: Help on SQLyog Did you set the password for root? did you grant yourself permission on the DB you are trying to access? Nestor :-) -Original Message- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:45 AM To: [EMAIL PROTECTED] Subject: Help on SQLyog Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Thanks --Kevin - 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
granting does not give the correct privileges
Is this an error in Mysql? I do the follwing command from a shell grant insert on mydb.* to username@localhost identified by user 'pwd'; When I check the permissions the insert_priv field on user table of mysql db is set to 'N'. Why is that? I can change the privileges by giving an update command. Any ideas?, Nestor :-) - 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
ODBC gets to mysql db with incorrect password
I have a db and a user with a pwd is allowed to access it. If my user and pwd is incorrect my php scripts can not access the db, which is what I expect. I colleague of mine just went into Mysql db using OBDC connection using microsoft Data source tool(I do not know much about microsoft) and he was able to access the Mysql db. I even went ahead and changed the password and did not tell him to what and he was still able to access Mysql db. He even make a connection but entering a bunch of characters. How is this possible? The database has only 2 user that are allow to access the db meaning there are only 2 entries in the user table of the Mysql db one of them being root. Any ideas? Thanks, Nestor :-) - 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: new mysql database
Sounds like you have a script an generally you run mysql script.sql and the database and tables get created. Make sure that the script creates your database and tables. Nestor :-) -Original Message- From: lin ad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 5:56 PM To: [EMAIL PROTECTED] Subject: new mysql database first, when i installed rh 7.3 i chose mysql and php and apache, i have tested apache and php independently and they work fine. next i can login into mysql with mysql -utest fine, basically, i have the mysql server running but never had a database. now i have a database but i don't know where to put it. now i have it in a temp dir. it is a file.sql . i am not sure but are databases 1 .sql file? i am not even sure if that is even a database file? i ftp'd all the .php files and put them in my /var/www/html there was also .sql file but i don't know what it is for or why it is there? that is the one that i opened and is default.sql, and i do not know what to do with that, when i open http://127.0.0.1 i get an error unable to connect to database server in /var/lib/mysql/mysql there are .myi and .myd and .frm files, i created none of this, i also did a mysqladmin create newdb then mysqluse newdb then put my file.sql file in that directory, when i do a mysqlstatus the newdb is current database, but i still get unable to connect to database, i just am not getting it, if the .sql file isn't the database then what is, the default.sql file inside says MySQL dump 8.21 but the file.sql when opened up says #database backup for shop.com #database: shop_ #database server: localhost so i mysqladmin create shop_ put the file.sql in /var/lib/mysql/shop_ then mysqluse shop_ mysqlstatus current database: shop_ still i get an error unable to connect to server any suggestions? __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.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 - 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: Connecting to remote MySQL server
IT is working as of yesterday. The problem was that I was granting select, insert, update privileges to the webuser and the change would not appear in the user table of the mysql database. Learn a new one yesterday. I try changing the privileges using the GRANT on an existing user and they do not change. I think this might be an error. I try this on several machines and the solution is to performa a query on the privileges on the user table of the mysql database. Nestor :-) On Fri, 20 Sep 2002 09:48:09 -0700 Clayburn W. Juniel, III [EMAIL PROTECTED] wrote: On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote: Hi, I am on the machine 192.168.0 230, and I am trying to connect to the server on 192.168.0.10. mysql -h 192.168.0.10 -u username -p I get back ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111) OK, so I tried to connect to the local server mysql -h 192.168.0.230 -u username -p And I get back ERROR 1130: Host '192.168.0.232' is not allowed to connect to this MySQL mysql -h 192.168.0.230 -u username -p is correct. But when you created the grant for this user, you needed to list the host as 192.168.0.230 or I think % might have worked. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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 - 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