Results 1 to 6 of 6

Thread: MySQL root password?

  1. #1
    Join Date
    Oct 2005
    Posts
    19
    Rep Power
    10

    Default MySQL root password?

    Hello,

    I would like to utilize the mysql db server that zimbra installs to host other databases.. Where can I find the root password that zimbra sets on installation?

  2. #2
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default localconfig

    zmlocalconfig -s | grep mysql

  3. #3
    Join Date
    Oct 2005
    Posts
    19
    Rep Power
    10

    Default

    Quote Originally Posted by marcmac
    zmlocalconfig -s | grep mysql
    perfect, thanks

  4. #4
    Join Date
    Feb 2006
    Location
    Pune, India
    Posts
    294
    Rep Power
    10

    Default

    This works only with the mysql bundled with Zimbra, but not with the MySQL existing on the system.

    Code:
    /opt/zimbra/bin/mysql -u root -p --host localhost --port 7306
    So, if, as a user other than "zimbra", I try to access mysql on port 7306 using mysql client ("mysql") existing on my system, it wont let me connect.

    Code:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    Is this normal behaviour? I am using:
    ZCS 4.0.0 GA.
    mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3
    Linux 2.6.9-34.0.1.EL #1 Wed May 24 07:40:56 CDT 2006 i686 i686 i386 GNU/Linux
    CentOS 4.3
    Actually, I want to be able to use "mysqldump" which is also failing with a similar error:

    Code:
    mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
    Any ideas why this is failing?
    Last edited by czaveri; 09-14-2006 at 08:40 AM.
    Regards,

    Chintan Zaveri
    (Yet another ZIMBRAN!)

    "Dhundhne par Bhagwan bhi ..."

  5. #5
    Join Date
    Feb 2006
    Location
    Pune, India
    Posts
    294
    Rep Power
    10

    Default

    Ok, I just realised that this is because the mysqldump or mysql client is trying to connect to port 3306 despite being explicitly asked to connect to port 7306 by using switches:

    Code:
    -P 7306
    _OR_

    Code:
    --port=7306
    Googling now to find out why this is happening...

    If anyone knows please post,

    Thanks,
    Regards,

    Chintan Zaveri
    (Yet another ZIMBRAN!)

    "Dhundhne par Bhagwan bhi ..."

  6. #6
    Join Date
    Feb 2006
    Location
    Pune, India
    Posts
    294
    Rep Power
    10

    Default

    Code:
    man mysql
    provided the hint.

    To use "mysql" client other than the one provided by Zimbra, socket should also be mentioned. The command that works is:

    Code:
    mysql --port=7306 --socket=/opt/zimbra/db/mysql.sock -u root -p
    Regards,

    Chintan Zaveri
    (Yet another ZIMBRAN!)

    "Dhundhne par Bhagwan bhi ..."

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. svn version still won't start
    By kinaole in forum Developers
    Replies: 0
    Last Post: 10-04-2006, 06:47 AM
  3. Replies: 16
    Last Post: 09-07-2006, 06:39 AM
  4. Login does not appear
    By alexz in forum Administrators
    Replies: 10
    Last Post: 04-18-2006, 06:46 AM
  5. Seeming variety of problems on suse-9.1
    By Crexis in forum Installation
    Replies: 52
    Last Post: 03-03-2006, 11:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •