Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Jan 2011
    Posts
    79
    Thanks
    7
    Thanked 0 Times in 0 Posts

    why is mysqlslap giving access denied error?

    i found the executable in /usr/bin/mysqlslap
    i did a mysql> SHOW VARIABLES LIKE '%version%';

    and got:
    protocol_version | 10 |
    | version | 5.1.41-3ubuntu12.10 |
    | version_comment | (Ubuntu) |
    | version_compile_machine | i486 |
    | version_compile_os | debian-linux-gnu

    i run mysqlslap:

    helloises@helloise:~/github_mira/rainbow_code/phoenix$ /usr/bin/mysqlslap --user=traffic2 --password=password --auto-generate-sql -vv
    Building Create Statements for Auto
    Building Query Statements for Auto
    Parsing engines to use.
    Starting Concurrency Test
    /usr/bin/mysqlslap: Cannot drop database 'mysqlslap' ERROR : Access denied for user 'traffic2'@'localhost' to database 'mysqlslap'


    in my datatbases.yml i have:
    dev:
    propel:
    param:
    dsn: mysql:dbname=traffic2;host=localhost
    classname: PropelPDO
    param:
    username: traffic2
    password: password

    why am i getting that error? please help
    can somebody please help???

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts
    Cannot drop database
    Mybe you don't have rights to do that. Google for GRANT ALL....
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #3
    New Coder
    Join Date
    Jan 2011
    Posts
    79
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by BubikolRamios View Post
    Mybe you don't have rights to do that. Google for GRANT ALL....
    the traffic 2 DB is my working DB. my website and mobi site connect to this db. i log in every day with: mysql -u traffic2 -p traffic2 and i use the same password everyday. when i set this up many moons ago i did:

    mysql -u root -p
    > CREATE DATABASE traffic2 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
    > CREATE USER traffic2;
    > GRANT ALL ON traffic2.* TO 'traffic2'@'localhost' IDENTIFIED BY 'password';

    anything im missing?
    thanks

  • #4
    New Coder
    Join Date
    Jan 2011
    Posts
    79
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Resolved

    finally got it to work thanks all


  •  

    Posting Permissions

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