Re: MySQL backup script

From: Peter Afonin (peter_at_gudzon.net)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 12:40:51 -0800

Thank you, Gordon.

Sorry, I'm not that Unix-aware to work with ssh. I can use commands in
Windows, but not Unix. Could you please just tell me what is incorrect? Or
tell me what command should I use to login to mysql database - I can try.

My account login is pva,

My database login is test, so it should be pva_test.

My database password is test.

Thank you,

Peter

"Gordon Burditt" <gordon@hammy.burditt.org> wrote in message
news:cqer85$ujc@library1.airnews.net...
> In article <C_adnQM9S9ej6lfcRVn-2g@speakeasy.net>,
> Peter <pva@speakeasy.net> wrote:
> >Thank you, Gordon.
> >
> >Tried to follow your recommendations.
> >
> >Created a user test with password test, gave all rights, database
ddt2_dmf.
> >Now my file looks like this:
> >
> >#!/bin/sh
> >date=`date '+%m-%d-%y'`
> >mysqldump -utest -ptest ddt2_dmf >
> >/home/ddt2/mysql_backup/ddt2_test.$date.sql
> >chown ddt2:ddt2 mysql_backup -R
> >
> >Getting error:
> >
> >mysqldump: Got error: 1045: Access denied for user: 'test@localhost'
(Using
> >password: YES) when trying to connect
> >
> >What am I still doing wrong?
>
> You have the user/password set up incorrectly.
> Can you log in with the command-line client ('mysql') using that
> user name, password, and database?
>
>
>
> Gordon L. Burditt

Relevant Pages

  • Re: MySQL backup script
    ... I can use commands in ... Could you please just tell me what is incorrect? ... tell me what command should I use to login to mysql database - I can try. ... My database login is test, ...
    (php.general)
  • Re: MySQL backup script
    ... I can use commands in ... Could you please just tell me what is incorrect? ... tell me what command should I use to login to mysql database - I can try. ... My database login is test, ...
    (alt.php)
  • Re: if AND
    ... when i check for this state it just simply skips to the incorrect ... login. ... you should be using the $_SESSION array. ... Status is a textfield in a table in a database. ...
    (comp.lang.php)
  • Re: if AND
    ... when i check for this state it just simply skips to the incorrect ... login. ... you should be using the $_SESSION array. ... Status is a textfield in a table in a database. ...
    (comp.lang.php)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)