Re: newbee error (1044)

[Shawn Sharp]

Dilipkumar,

Thanks much for the tip....it did the job!

Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:

[EMAIL PROTECTED]:/usr/bin> mysqlshow
+-----------+
| Databases |
+-----------+
| test      |
+-----------+
[EMAIL PROTECTED]:/usr/bin>

Here is where BOTH databases reside:

wdshss:/var/lib/mysql # ll
total 20527
drwxr-xr-x   5 mysql mysql      464 2006-03-23 08:46 .
drwxr-xr-x  50 root  root      1296 2006-03-20 21:34 ..
-rw-------   1 mysql mysql       99 2005-10-21 12:20 .bash_history
drwx------   4 mysql mysql       96 2006-03-23 07:02 data
-rw-rw----   1 mysql mysql 10485760 2006-03-23 08:46 ibdata1
-rw-rw----   1 mysql mysql  5242880 2006-03-23 08:46 ib_logfile0
-rw-rw----   1 mysql mysql  5242880 2006-09-17 09:15 ib_logfile1
drwx------   2 mysql mysql     1584 2006-03-23 07:03 mysql
-rw-rw----   1 mysql mysql     1767 2006-03-23 08:46 mysqld.log
-rw-rw----   1 mysql mysql      503 2006-03-23 06:44 mysqld.log.1
-rw-r--r--   1 mysql mysql      402 2006-03-14 19:30 mysqld.log.4.gz
-rw-rw----   1 mysql mysql        6 2006-03-23 08:46 mysqld.pid
srwxrwxrwx   1 mysql mysql        0 2006-03-23 08:46 mysql.sock
drwx------   2 mysql mysql       48 2006-03-23 07:03 test
-rw-r--r--   1 mysql mysql        0 2006-09-17 09:15 update-stamp-4.1
-rw-rw----   1 mysql mysql        6 2006-03-14 06:49 wdshss.site.pid
wdshss:/var/lib/mysql #


On 3/23/06, Dilipkumar <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Use
>
> /usr/bin/mysql_in­stall_db --datadir=/mysql/data --user=mysql
>
> This might help ypu to solve the problem.
>
>
>
> Shawn Sharp wrote:
>
> >I get the following error while trying to create the following database
> >
> >mysql mysql < zm_cre­ate.sql.in
> >ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database
> >'mysql'
> >
> >I tried to run the following script
> >
> >/usr/bin/mysql_in­stall_db --user­=mysql
> >
> >It does not create mysql database in the correct directory I still only
> see
> >the 2 databases
> >
> >/us­r/bin/mysqlshow
> >+-----------+
> >| Databases |
> >+-----------+
> >| test      |
> >+-----------+
> >
> >Thanks
> >
> >
> >
>
>
> --
> Thanks & Regards
> Dilipkumar
> DBA Support
>
> ********** DISCLAIMER **********
> Information contained and transmitted by this E-MAIL is proprietary to
> Sify Limited and is intended for use only by the individual or entity to
> which it is addressed, and may contain information that is privileged,
> confidential or exempt from disclosure under applicable law. If this is a
> forwarded message, the content of this E-MAIL may not have been sent with
> the authority of the Company. If you are not the intended recipient, an
> agent of the intended recipient or a  person responsible for delivering
> the
> information to the named recipient,  you are notified that any use,
> distribution, transmission, printing, copying or dissemination of this
> information in any way or in any manner is strictly prohibited. If you
> have
> received this communication in error, please delete this mail & notify us
> immediately at [EMAIL PROTECTED]
>
> www.sify.com - your homepage on the internet for news, sports, finance,
> astrology, movies, entertainment, food, languages etc
>