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
(text/plain)