help with startup accesss

Hello, I've reinstalled my system (Mac OS 10.3 Server). In trying to get MySQL going again. I can run mysql_install_db, but I can't access the mysql db and I can not set a root user password. If I try to login: mysql -u root it says access denied to [EMAIL PROTECTED] If I simply type mysql (no

moving databases

Ok, I've set my root password and have found (by creating a db) that the databases are stored (Mac OSX Server 10.3) in /private/var/mysql. I have my old system on a separate hard disk; however, mysql is not functioning there, but I do have my databases there. Can I copy these database to

bit of help? root@localhost denied

Hello, I've reinstalled my system (Mac OS 10.3 Server). In trying to get MySQL going again. I can run mysql_install_db, but I can't access the mysql db and I can not set a root user password. If I try to login: mysql -u root it says access denied to [EMAIL PROTECTED] If I simply type mysql (no

establishing a relationship

I have a friend teaching me but I want more :-) (second opinions), please. A simple Database: 2 tables a one-to-many relationship each table has a Primary Key: table1 (one) Primary Key = peopleID; table2 (many) Primary Key = machinesID Normally, I would put the peopleID also in table2 as a

Re: establishing a relationship

Yes, a linking table or a map table or a join table. Linking is what I see it called in books I have; yes I understand that. I hope to understand the advice for a third more thoroughly, too. I am doing this for practice so the theory of what I'm being taught is what I'm after and afaik it

Re: Inserting data?

I'd be glad to share.. you mean what the db is supposed to be? Ok, there are 3 tables: table1 = people, people_id = primary key table2 = machines, machines_id = primary key One person can have many machines, one machine can only be assigned to one person. The way I was taught, in my limited

Re: becoming unconfused

I just came from the bookstore where I perused Mastering MySQL 4. Specifically, I wanted to know how to specify a Foreign Key. After a thorough, albeit short lived search, and reading every page the index on Foreign Key pointed to, I deduced that all one needs do is put the blasted field

swapping data

how can I swap the data between to columns in the same table? Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: becoming unconfused

Thanks, so is this correct, do I run this on table1? table1 table2 studentID --PK classID --PK student_name class_name studentID (foreign key) [CONSTRAINT symbol] FOREIGN KEY (studentID) REFERENCES table2

Re: becoming unconfused

I appreciate this and I have read it several times, the problem is it ain't easy to find a practical example, one with real data. That would I could figure out what symbol was. In fact what I am doing now is trying to build a small DB so I can learn these things --the books and I've got lots

confusion clearing up

Ok, list friends... I think I get it. My tables are ALREADY populated except for a Foreign Key column. What I think I get is that there is no way that the DB can possibly know or be told which row from the master table to insert/correspond (Foreign Key) to which row(s) in the slave (many)

my first select

I made a small DB of people and machines, where one person can have more than one machine, each machine can be assigned to only one person. people | machines, one-to-many. I have a primary key ID field in each table (peopleID, machineID) and in the machines table I have the peopleID, the

Re: my first select

SELECT thankyou, thankyou FROM thankyou.thankyou WHERE thankyou = thankyou. It's nice to end the weekend and go to bed with one small success! Though my persistence is unending. ;-) I added ORDER BY lastName on the end, et viola! Thanks and goodnight! Ted On Monday, June 2, 2003, at 03:26 AM,

Inserting data?

I have a table, in the table is a field called name_id; in a second table (a linking table) I also have the field name_id, this should be the same/reference the same name_id as in the first table. The first table is fully populated. How do write a SQL statement to get the data from the

database newbie

Ok, since this is THE place for MySQL and related discussion/questions, here goes: I'm trying to understand Keys, I do for the most part, but in reading the well recommended book 'Database Design for Mere Mortals' I got a bit confused. A check for worthy primary key designation is to ask what

establishing relationship

Someone here (Mike) has been quite kind and responded elaborately to me off-list, thanks Mike! I wanted to go ahead and put this final question here: In my database that I'm working on I already have data --a 'one to many' people to machines db. I had made each table with a primary key field

Re: database permissions

On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote: * [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my system the mysqld deamon runs as mysql and files are owned by

Re: database permissions

Thanks, I get: (B (B[localhost:~] ted% ps ax |grep mysql (B 180 ?? S 0:00.04 sh /usr/bin/safe_mysqld (B 197 ?? S 0:00.21 /usr/libexec/mysqld (B 2054 std R+ 0:00.00 grep mysql (B (Bdoes this look good? safe? (B (BThanks again, (BTed (B (B (B (BOn Wednesday, May

RDBMS listserv?

I'm trying to study some books, like Database Design for Mere Mortals. I'm finding that I could really use a listserv to get some occasional questions out. Anyone know of any? (Preferably a listserv, but forums will do as well.) Thanks, Ted -- MySQL General Mailing List For list archives:

Re: help with load from file

We, ok. Thank you all. This worked quite nicely and I learned something to boot! TR On Tuesday, May 27, 2003, at 11:00 PM, Steve Gums wrote: The numbers should be without the quotes and the end of line character can stay as is. Once you have this you should be able to do something like

database permissions

What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: database permissions

oops, oh yeah. I fixed it. TR On Wednesday, May 28, 2003, at 05:56 AM, [EMAIL PROTECTED] wrote: What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list

help with load from file

Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column

Re: help with load from file

I also have it prepared like this: 1,Mac,SE30,314784,LOV,115,,, 2,Mac,Performa6300CD,338211,LOV,109,,, Also, I did have all the \ as \N previously. But what about at the end of lines. What I had with \N wouldn't take so I was hoping someone might out what the error might be coming from by

Re: help with load from file

Yes, I simply don't understand this: === LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES

about hostnames after setup of MySQL

Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also shows up at my terminal prompt (instead of the usual localhost). if i look

MySQL database design

MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map? Or you can advise me of how to arrange my keys, or otherwise develop this db?

Re: Mysql Problem Query

did you also install the databases that are part of the mysql installation? -Ll on 8/11/02 5:59 AM, Anish Mathew, typed: my sqlserver is not running when i issue the command mysql the response i got was cant connect to local mysql server through socket /var/lib/mysql.sock (111)

Re: MySQL database design

on 8/11/02 2:47 PM, Pekka Saarinen, typed: At 8/11/2002, you wrote: MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map?

Re: MySQL 3.23.51 install on OS X

try using localhost. you have to set the hostname in the install script. on 8/10/02 1:08 PM, Alex Pilson, typed: I am installing a new MySQL installation on a new Xserve and I am getting this message; [xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db Sorry, the host

MySQL and Web Objects5 (OS X)

Does anyone know how to cause WO to recognize and offer MySQL as an adaptor? i.e., how to get WO5 to use MySQL?) Thanks in advance. Ted Rogers FSU MathNet | Apple Systems - Before posting, please check:

use of RENAME???

[mysql] is this how to change the the name of an existing populated db? RENAME DATABASE old_name TO new_name; TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

granting ALL!

can i create a new user and 'grant all' to that user on all dbs and THEN add/import new databases and that user will still have all permissions on those as well? - Before posting, please check:

Re: Permission

this page is helping me A LOT! thank you. At 3:46 PM +0300 7/5/01, Ilan Fait wrote: Hi, Check out this URL it is very good to start with. URL: http://home.ubalt.edu/abento/797/mysql/ I hope that it will help Best Regards, Ilan

thank you all!

i'm in the dbs and the book i wanted to be in!!! it was http://home.ubalt.edu/abento/797/mysql/ that helped so much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

got nowhere faster :(

[MySQL] what does this mean and how can i fix it? Access denied for user: 'niban@localhost' to database 'tracking'Could not drop database tracking thanks. p.s. in this case i believe drop refers to adding or creating... if that is possible... because i am trying to add this db with a script.

Re: Mac OS X Server 10.0.4 and startup

go here: and put it in that folder. http://www.diax.ch/users/liyanage/software/macosx/mysql-startupitem.pkg.tar.gz note that the user might have to be changed from its default mysql at the line: /usr/local/bin/safe_mysqld --user=mysql --err- TR At 11:06 PM -0400 7/5/01, Patrick Larkin

still struggling, still here! owner vs. root

MySQL. i installed a a package install of the latest MySQL -of the unix [Mac OS X] variety. here's what i did (after the package installed installed itself): - i did this logged in as an administrator (me) AND below wherever it says mysql (as username) i entered my own username... so on the

started over! root and user pw (easy questions?)

where in the manual does it explain how to set up the root password after an install? i understand that should be the first thing done. as the admin of mysql on my server, should the only method i use to login be by root and said password? OR should i make another username/password for myself

Re: Connect mySQL with HTML or something

yes. get MySQL/PHP Database Applications. by J. Greenspan and Brad Burger. enjoy. p.s. your hotmail email addy doesn't work. At 2:03 PM -0300 6/21/01, Laura Lía Marcello wrote: I need to know if there is a way to create a searchable database that returns results as a web page... As you can

change table name?

how do i change a table's name without recreating it? - 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

what does this mean please?

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and how you fix it? thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Knowing if a table exits

1. mysql SHOW databases; 2. mysql USE MessageNotification; 3. mysql SHOW TABLES FROM MessageNotification; hth At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote: How can I query the database to know that a specific table exists in a given database. for example my database is

complete delete to begin again, instructions please

could someone tell me how to make a clean sweep of MySQL from my system so i can start over? (i need to toss phpMyAdmin temporarily too i get asked for a password at every bend and none of the ones i use' hardly ever' work ;) e. i just don't get the root stuff and winder whay i can't

please help (dumb permissions thing?)

Access denied for user: '@localhost' to database 'netsloth'Could not drop database netsloth (i asume drop means to drop 'in' in this case?) is what i get back when i try to install the db 'netsloth.dump' from J Greenspan's book and CD. please tell this newcomer what he has to do to fix this

RE: .dump files

i guess that is confusing to me because it says query. i'm really stuck though -see my recent 'please help' post to the mysql list. thanks. At 2:48 AM -0600 6/18/01, Chris Bolt wrote: thank you. that's sort of what i thought. now for the silly question: i know how to do it with

simple commands, no joy

what's wrong with this please: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump; - (as i understand it a .dump = .sql file) thanks. - Before posting, please check:

RE: .dump files

i had some others that i browsed into phpmyadmin and they seemed to work, but others, like this one, showed a Query error -but that method of imported population was probably wrong anyway, i guess. thanks here's the file: # MySQL dump 6.8 # # Host: localhostDatabase: netsloth

RE: .dump files

thank you. that's sort of what i thought. now for the silly question: i know how to do it with 'monitor' (CLI), but where/how do you import using phpMyAdmin, please? (this i'd love to know :) i looked through the manual but didn't see anything for import db. Ted At 4:30 AM -0600 6/17/01,

RE: content management.. was .dump files

i'd like to use the db i sent but unless i'm importing wrong there's an error in it somewhere and thus it won't import. i don't suppose anyone who has it could take a peek? or knows where i can get something like it? Thank you. Ted Rogers At 4:30 AM -0600 6/17/01, Chris Bolt wrote: That is

import entire db (small) via phpMyAdmin

Is importing an entire db (small) into MySQL via phpMyAdmin possible? If so, how. Thanks in advance. Ted Rogers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

.dump files

hello, i have some files from a Cd that are .dump files, how do i get these db into mysql? (is it possible using phpMyAdmin). again, these are .dump files, not .sql files. thank you. - Before posting, please check: