Thanks Tom. So I need to create a new MySL for every site.<br clear="all"><div>:-)~MIKE~(-:</div>
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 11:09 PM, Tom Haws <span dir="ltr"><<a href="mailto:tom.haws@gmail.com" target="_blank">tom.haws@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div>I'm no wizard at this, but I always start mysql like this:<br><br></div>mysql -uroot -p<br><br></div>Now, are you saying you gave Joomla the mysql root username and password to use?<br></div>
<div class="gmail_extra">
<div class="im">
<br clear="all"><div>--<br>"To forgive is the highest, most beautiful form of love. In return, you will receive untold peace and happiness." - Dr. Robert Muller</div>
<br><br></div><div><div class="h5"><div class="gmail_quote">On Tue, Feb 26, 2013 at 10:18 PM, Michael Havens <span dir="ltr"><<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
so is this for each 'site' I create? I did create a user and I am told:<div><font color="#660000"><br></font></div><div><div><font color="#660000"><span style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:14px;line-height:20px;background-color:rgb(252,248,227)">An error occurred while trying to create the database <a href="http://onlineworkfinder.us" target="_blank">onlineworkfinder.us</a>.</span><br style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:14px;line-height:20px;background-color:rgb(252,248,227)">
<span style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:14px;line-height:20px;background-color:rgb(252,248,227)">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!.</span></font><br clear="all">
<div><br></div></div><div> 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. </div>
<div><br></div><div>Well, this is strange: I can start mysql as my user but not with sudo.</div><div><br></div><div><div><font color="#660000">$ sudo mysql</font></div><div><font color="#660000">ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)</font></div>
</div><div><br></div><div>So what do I need to do?</div><div>:-)~MIKE~(-:</div><div><div>
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 6:45 PM, Tom Haws <span dir="ltr"><<a href="mailto:tom.haws@gmail.com" target="_blank">tom.haws@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">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.<br>
</div><div class="gmail_extra"><br clear="all"><div>--<br>"To forgive is the highest, most beautiful form of love. In return, you will receive untold peace and happiness." - Dr. Robert Muller</div><div><div>
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 5:49 PM, Michael Havens <span dir="ltr"><<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I think I know what I need to do.... add my user to the mysql group (or whatever it is called).<br clear="all"><div>:-)~MIKE~(-:</div><div><div>
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 5:28 PM, Michael Havens <span dir="ltr"><<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
so how do I set it up correctly? I mean it was working!<br clear="all"><div>:-)~MIKE~(-:</div><div><div>
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 3:47 PM, Michael Havens <span dir="ltr"><<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
but before I created the link it went to the admin page.<br clear="all"><div>:-)~MIKE~(-:</div><div><div>
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 3:41 PM, keith smith <span dir="ltr"><<a href="mailto:klsmith2020@yahoo.com" target="_blank">klsmith2020@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top"><br>Sounds like your install is not installed correctly. <br><div><br>------------------------<br>
Keith Smith<br><br>--- On <b>Tue, 2/26/13, Michael Havens <i><<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></i></b> wrote:<br></div><blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;padding-left:5px">
<div><br>From: Michael Havens <<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>><br>Subject: Re: joomla<br>To: "Main PLUG discussion list" <<a href="mailto:plug-discuss@lists.phxlinux.org" target="_blank">plug-discuss@lists.phxlinux.org</a>><br>
</div>Date: Tuesday, February 26, 2013, 3:05 PM<div><div><br><br><div>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.<br clear="all">
<div>:-)~MIKE~(-:</div>
<br><br><div>On Tue, Feb 26, 2013 at 6:55 AM, keith smith <span dir="ltr"><<a rel="nofollow" href="http://mc/compose?to=klsmith2020@yahoo.com" target="_blank">klsmith2020@yahoo.com</a>></span> wrote:<br><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top"><br>Mike,<br><br>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.<br>
<br>Take a look at these tutorials <a rel="nofollow" href="http://dev.mysql.com/doc/refman/5.6/en/tutorial.html" target="_blank">http://dev.mysql.com/doc/refman/5.6/en/tutorial.html</a>. They should help you understand the what and how of databases, specifically MySql.<br>
<br>Here is some PHP info on how to work with MySql databases <a rel="nofollow" href="http://www.php.net/manual/en/set.mysqlinfo.php" target="_blank">http://www.php.net/manual/en/set.mysqlinfo.php</a>.<br><br>I would recommend understanding the basics before trying to install Joomla on your local LAMP install. <br>
<div><br><br><br>------------------------<br>
Keith Smith<br><br>--- On <b>Tue, 2/26/13, Michael Havens <i><<a rel="nofollow" href="http://mc/compose?to=bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></i></b> wrote:<br></div><blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;padding-left:5px">
<div><br>From: Michael Havens <<a rel="nofollow" href="http://mc/compose?to=bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>><br>Subject: Re: joomla<br>To: "Main PLUG discussion list" <<a rel="nofollow" href="http://mc/compose?to=plug-discuss@lists.phxlinux.org" target="_blank">plug-discuss@lists.phxlinux.org</a>><br>
</div>Date: Tuesday, February 26, 2013, 12:27 AM<div><div><br><br><div><div><br></div><div>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.</div>
<div>:-)~MIKE~(-:</div>
<br><br><div>On Tue, Feb 26, 2013 at 12:17 AM, Michael Havens <span dir="ltr"><<a rel="nofollow" href="http://mc/compose?to=bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>></span> wrote:<br><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
why is it asking for database info?! oh bother.<div>well I tried to create a database but this is the error it gives:</div><div><font color="#330000"><br></font></div><div><font color="#330000"><span style="font-size:14px;line-height:20px;background-color:rgb(252,248,227)">An error occurred while trying to create the database <a rel="nofollow" href="http://onlineworkfinder.us" target="_blank">onlineworkfinder.us</a>.</span><br style="font-size:14px;line-height:20px;background-color:rgb(252,248,227)">
<span style="font-size:14px;line-height:20px;background-color:rgb(252,248,227)">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!.</span></font><br clear="all">
<div><br></div><div>So please, what do I need to do. Should I chown something? If so, what?</div><div>:-)~MIKE~(-:</div>
<br></div>
</blockquote></div><br>
</div><br></div></div><div>-----Inline Attachment Follows-----<br><br><div>---------------------------------------------------<br>PLUG-discuss mailing list - <a rel="nofollow" href="http://mc/compose?to=PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br><a rel="nofollow" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a></div>
</div></blockquote>
</td></tr></tbody></table><br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a rel="nofollow" href="http://mc/compose?to=PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a rel="nofollow" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br></blockquote></div><br>
</div><br>-----Inline Attachment Follows-----<br><br><div>---------------------------------------------------<br>PLUG-discuss mailing list - <a href="http://mc/compose?to=PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br><a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a></div></div></div>
</blockquote></td></tr></tbody></table><br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div><br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br></blockquote></div><br></div></div></div>
<br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br></blockquote></div><br></div></div></div>
<br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br></blockquote></div><br></div></div></div>
<br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br></blockquote></div><br>