ok, fyi, the below worked fine.
________________________________now...
as readers here may know, this db newbie had problems getting MySQL
up and running -much like the other person with pwd problems. i
erased the drive (OS X pb/Tenon iTools), reinstalled and all is well,
it even starts itself.
i have created one db with several (3) tables of my own; i have not
deployed it or even made the scripts (php) for it yet -i will :)
now i know the manual talks about a password to sign in to MySQL and
to grant privileges for dbs. so far i have always been logged into my
COMPUTER as root.
i have set *no other passwords* anywhere. last time i messed with the
-p flag in MySQL i apparently got everything totally whacked.
1) should i establish a password with iTools admin? if so, should i
do that first? does that affect the MySQL that i downloaded from
Tenon's site?
2) should i establish a password with MySQL? is this a 'root' password?
3) and finally..., just for me, as root(?), must i establish a
password for each and every db?
i will figure out how to assign grants(s) and passwords for other
users (besides me later; however, knowledge of the above (1, 2, 3)
will expedite that greatly.
thank you in advance for any help.
thanks also for your patience with newbies, as you must know "newbie"
focus (mine anyway) is spread out rather thinly all over the place!
RTM in not always easy to grasp and tediously slow.
TR
At 8:41 PM +0100 2/11/01, jcmaes wrote:
>Hi,
>
>This works perfect, I made it many times.
>
>The only point is that you may have to define access rights for that db. Do
>so by using "grant" or copying the relevant records from the MySql database.
>
>regards,
>
>JC
>
>
>
>----- Original Message -----
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Sunday, February 11, 2001 7:55 PM
>Subject: copying databases
>
>
>> hi,
>>
>> i'm a stu so don't all the time in the world... who does!
>>
>> last night i took a MySQL database (a folder i got out of the
>> MySQL/data folder) home and copied into the data folder on my
>> machine, is this ok?
>>
>> unfortunately i cannot simply 'see if it runs' because i am having
>> those terrible socket and password problems and so MySQL won't run at
>> home, yet. :(
>>
>> but once i get it i want to be prepared.
>>
>> thank you.
>>
> > Ted
---------------------------------------------------------------------
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
