Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • pike pike
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 104
    • Issues 104
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • pikelang
  • pikepike
  • Issues
  • #1562
Closed
Open
Issue created Apr 19, 2001 by Peter Bortas@zinoOwner

The MySQL module could give an access denied error message

Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=1562

Reported by Mattias Wingstedt, Idonex AB wing@roxen.com

If the process user doesn't have permission to access a MySQL database and no username or password is sent to the MySQL module you get a "Couldn't select database" error instead of an "Access denied" error.

Pike v7.0 release 312 running Hilfe v2.0 (Incremental Pike Frontend)
> Sql.sql( "mysql://localhost/roxen" );
Mysql.mysql(): Couldn't select database "roxen"
lib/modules/Sql.pmod/mysql.pike:
    create("Mysql.mysql(): Couldn't select database
\"roxen\"\n",({({"/web/pik

e/7.0.312/lib/master.pike",1107,/master._main,,,1}),({0,0,Hilfe.StdinHilfe

}),({"/web/pike/7.0.312/lib/modules/Tools.pmod/Hilfe.pmod",667,,,0}),,,7})

)
lib/modules/Sql.pmod/sql.pike:215: create("localhost","roxen",0,0)
-:1: ___Foo4711()
> quit
Exiting.

Pike v7.0 release 312 running Hilfe v2.0 (Incremental Pike Frontend)
> Sql.sql( "mysql://foo:bar@localhost/roxen" );
Mysql.mysql(): Couldn't reconnect to SQL-server
Access denied for user: 'foo@localhost' (Using password: YES)
lib/modules/Sql.pmod/mysql.pike:
    create("Mysql.mysql(): Couldn't reconnect to SQL-server\nAccess denied
for
     user: 'foo@localhost' (Using
p"+[15],({({"/web/pike/7.0.312/lib/master.pi

ke",1107,/master._main,({"bin/pike"}),,,0}),({0,0,Hilfe.StdinHilfe}),,,8})

)
lib/modules/Sql.pmod/sql.pike:211: create("localhost","roxen","foo","bar")
-:1: ___Foo4711()

bash-2.03$ mysql mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Assignee
Assign to
Time tracking