Thanks Tom. So I need to create a new MySL for every site.
:-)~MIKE~(-:


On Tue, Feb 26, 2013 at 11:09 PM, Tom Haws <tom.haws@gmail.com> wrote:

> I'm no wizard at this, but I always start mysql like this:
>
> mysql -uroot -p
>
> Now, are you saying you gave Joomla the mysql root username and password
> to use?
>
> --
> "To forgive is the highest, most beautiful form of love. In return, you
> will receive untold peace and happiness." - Dr. Robert Muller
>
>
> On Tue, Feb 26, 2013 at 10:18 PM, Michael Havens <bmike1@gmail.com> wrote:
>
>> so is this for each 'site' I create? I did create a user and I am told:
>>
>> An error occurred while trying to create the database onlineworkfinder.us
>> .
>> The user may not have enough privileges to create a database. The
>> required database may need to be created separately before you can install
>> Joomla!.
>>
>>  which says  he doesn't have the proper permissions.. But the username is
>> 'root'. Doesn't that mean he has permission to do anything? Please, tell me
>> what I need to do to give him the permissions he needs.
>>
>> Well, this is strange: I can start mysql  as my user but not with sudo.
>>
>> $ sudo mysql
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: NO)
>>
>> So what do I need to do?
>> :-)~MIKE~(-:
>>
>>
>> On Tue, Feb 26, 2013 at 6:45 PM, Tom Haws <tom.haws@gmail.com> wrote:
>>
>>> You do need to create a MySQL user and database for Joomla.  And you do
>>> need to give that user all the required permissions on the Joomla
>>> database.  Then all you have to tell Joomla is the name of the database and
>>> the MySQL username and password.
>>>
>>> --
>>> "To forgive is the highest, most beautiful form of love. In return, you
>>> will receive untold peace and happiness." - Dr. Robert Muller
>>>
>>>
>>> On Tue, Feb 26, 2013 at 5:49 PM, Michael Havens <bmike1@gmail.com>wrote:
>>>
>>>> I think I know what I need to do.... add my user to the mysql group (or
>>>> whatever it is called).
>>>> :-)~MIKE~(-:
>>>>
>>>>
>>>> On Tue, Feb 26, 2013 at 5:28 PM, Michael Havens <bmike1@gmail.com>wrote:
>>>>
>>>>> so how do I set it up correctly? I mean it was working!
>>>>> :-)~MIKE~(-:
>>>>>
>>>>>
>>>>> On Tue, Feb 26, 2013 at 3:47 PM, Michael Havens <bmike1@gmail.com>wrote:
>>>>>
>>>>>> but before I created the link it went to the admin page.
>>>>>> :-)~MIKE~(-:
>>>>>>
>>>>>>
>>>>>> On Tue, Feb 26, 2013 at 3:41 PM, keith smith <klsmith2020@yahoo.com>wrote:
>>>>>>
>>>>>>>
>>>>>>> Sounds like your install is not installed correctly.
>>>>>>>
>>>>>>> ------------------------
>>>>>>> Keith Smith
>>>>>>>
>>>>>>> --- On *Tue, 2/26/13, Michael Havens <bmike1@gmail.com>* wrote:
>>>>>>>
>>>>>>>
>>>>>>> From: Michael Havens <bmike1@gmail.com>
>>>>>>> Subject: Re: joomla
>>>>>>> To: "Main PLUG discussion list" <plug-discuss@lists.phxlinux.org>
>>>>>>> Date: Tuesday, February 26, 2013, 3:05 PM
>>>>>>>
>>>>>>>
>>>>>>> I've already installed it on my local machine. The reason I'm
>>>>>>> thinking I need a database for each webpage is that I created a link to the
>>>>>>> webpage's location in /var/www in an experiment to be able to not store the
>>>>>>> page in /var/www but rather in ~/Documents/<etc> . Then when I went to the
>>>>>>> admin page it wanted to setup joomla again.
>>>>>>> :-)~MIKE~(-:
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Feb 26, 2013 at 6:55 AM, keith smith <klsmith2020@yahoo.com<http://mc/compose?to=klsmith2020@yahoo.com>
>>>>>>> > wrote:
>>>>>>>
>>>>>>>
>>>>>>> Mike,
>>>>>>>
>>>>>>> It appears you are thinking a DB is a physical thing like a static
>>>>>>> webpage.  It is physical in that it resides on your file system, however it
>>>>>>> is not like a static webpage.
>>>>>>>
>>>>>>> Take a look at these tutorials
>>>>>>> http://dev.mysql.com/doc/refman/5.6/en/tutorial.html.  They should
>>>>>>> help you understand the what and how of databases, specifically MySql.
>>>>>>>
>>>>>>> Here is some PHP info on how to work with MySql databases
>>>>>>> http://www.php.net/manual/en/set.mysqlinfo.php.
>>>>>>>
>>>>>>> I would recommend understanding the basics before trying to install
>>>>>>> Joomla on your local LAMP install.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ------------------------
>>>>>>> Keith Smith
>>>>>>>
>>>>>>> --- On *Tue, 2/26/13, Michael Havens <bmike1@gmail.com<http://mc/compose?to=bmike1@gmail.com>
>>>>>>> >* wrote:
>>>>>>>
>>>>>>>
>>>>>>> From: Michael Havens <bmike1@gmail.com<http://mc/compose?to=bmike1@gmail.com>
>>>>>>> >
>>>>>>> Subject: Re: joomla
>>>>>>> To: "Main PLUG discussion list" <plug-discuss@lists.phxlinux.org<http://mc/compose?to=plug-discuss@lists.phxlinux.org>
>>>>>>> >
>>>>>>> Date: Tuesday, February 26, 2013, 12:27 AM
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> I was thinking..... Do you need to create a new database for every
>>>>>>> new website? If so I think I need to chown the database or maybe add it to
>>>>>>> a group.
>>>>>>> :-)~MIKE~(-:
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Feb 26, 2013 at 12:17 AM, Michael Havens <bmike1@gmail.com<http://mc/compose?to=bmike1@gmail.com>
>>>>>>> > wrote:
>>>>>>>
>>>>>>> why is it asking for database info?! oh bother.
>>>>>>> well I tried to create a database but this is the error it gives:
>>>>>>>
>>>>>>> An error occurred while trying to create the database
>>>>>>> onlineworkfinder.us.
>>>>>>> The user may not have enough privileges to create a database. The
>>>>>>> required database may need to be created separately before you can install
>>>>>>> Joomla!.
>>>>>>>
>>>>>>> So please, what do I need to do. Should I chown something? If so,
>>>>>>> what?
>>>>>>> :-)~MIKE~(-:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> -----Inline Attachment Follows-----
>>>>>>>
>>>>>>> ---------------------------------------------------
>>>>>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org<http://mc/compose?to=PLUG-discuss@lists.phxlinux.org>
>>>>>>> To subscribe, unsubscribe, or to change your mail settings:
>>>>>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>>>>>>
>>>>>>>
>>>>>>> ---------------------------------------------------
>>>>>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org<http://mc/compose?to=PLUG-discuss@lists.phxlinux.org>
>>>>>>> To subscribe, unsubscribe, or to change your mail settings:
>>>>>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> -----Inline Attachment Follows-----
>>>>>>>
>>>>>>> ---------------------------------------------------
>>>>>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org<http://mc/compose?to=PLUG-discuss@lists.phxlinux.org>
>>>>>>> To subscribe, unsubscribe, or to change your mail settings:
>>>>>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>>>>>>
>>>>>>>
>>>>>>> ---------------------------------------------------
>>>>>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>>>>>>> To subscribe, unsubscribe, or to change your mail settings:
>>>>>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>> ---------------------------------------------------
>>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>>>> To subscribe, unsubscribe, or to change your mail settings:
>>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>>>
>>>
>>>
>>> ---------------------------------------------------
>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>>> To subscribe, unsubscribe, or to change your mail settings:
>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>>
>>
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>