On Wed, 04 Jun 2008 10:01:18 -0400
Frank Warmerdam <warmerdam@pobox.com> wrote:
Otto Dassau wrote:
> Hi Markus,
>
> On Fri, 23 May 2008 15:28:05 +0200
> "Markus Neteler" <neteler@osgeo.org> wrote:
>
>> On Fri, May 23, 2008 at 1:29 PM, Otto Dassau <otto.dassau@gmx.de> wrote:
>>> On Fri, 23 May 2008 05:59:02 -0400
>>> "Frank Warmerdam" <warmerdam@pobox.com> wrote:
>> ...
>>>> I'm no mysql guru, so go ahead and make a mysql database.
>>>> I presume it will be created off in some standard mysql location
>>>> instead of within the /osgeo/qgis area. I can't think of any practical
>>>> way to avoid that.
>>> yes, no problem. MySQL is running on that machine so I can prepair
>>> everything I need with sudo rights.
>> Keep in mind that the GRASS Wiki is using MySQL there on that blade.
>
> I don't have privileges to create a new mysql database for joomla on that
> server. Can you tell me how to get access to create a new database and give
> me admin rights?
Otto,
You have sudo priveledges on the telascience blade, so you can create
new databases. However, you might use those permissions with caution.
If you aren't too confident you know what you are doing, and whether it
might impact other use of the server, then ask for additional help.
Yes, I tried with my priveledges, but it doesn't work, so yes, I could need some
help. I tried to add a new database as root and odassau as you can see below,
but didn't succeed with access denied:
[odassau@xblade14-2 ~]$ sudo mysqladmin -u root -p create joomla_qgisweb
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[odassau@xblade14-2 ~]$ sudo mysqladmin -u odassau -p create joomla_qgisweb
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'odassau'@'localhost' (using password: YES)'
I am no mysql guru, so maybe someone can help, what user is allowed to create a
database under mySQL and what do I need to do and make wrong following the steps
described in the joomla manual (see below)?
#########
# 3.2.1. Create and Configure the MySQL Database
# To create the MySQL database run the following as the "root" user.
#
# [root@t1 tmp]# mysqladmin -u root -p create Joomla
# Enter password:
# [root@t1 tmp]#
# Now we need to create a MySQL user for Joomla! Here is a sample session. First
# you need to log in to MySQL as "root" and then create the user with all
# priviliges for the Joomla! database. In this example I created the user
# "joomla_admin" with the password "lockbox".
# [root@t1 tmp]# mysql -u root -p
# Enter password:
# Welcome to the MySQL monitor. Commands end with ; or \g.
# Your MySQL connection id is 60 to server version: 5.0.17-standard
# Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
# mysql> GRANT ALL PRIVILEGES ON Joomla.* TO joomla_admin@localhost
# IDENTIFIED BY 'lockbox'; Query OK, 0 rows affected (0.00 sec)
# mysql> flush privileges;
# Query OK, 0 rows affected (0.00 sec)
# mysql> quit
# Bye
# [root@t1 tmp]#
########
thanks a lot,
Otto
Best regards,