User Access to Database

Steve Kessler

• June 27, 2015 18:38

I am trying ensure the user I am running a bash script with has full access to my database via a my.conf file that specifies a valid username and password. I tried to locate the my.conf on my system and I do not see a way to do that. I think I know what I need to add to my.conf file but I am not sure where it is with cPanel. Thanks!

• 

  dalem

  • June 28, 2015 00:29

  located in your /home/usename and its .my.cnf (its hidden)

  0
• 

  feldon27

  • June 29, 2015 01:43

  I'm curious why you need a my.cnf file to do a bash script. Have you tried something like: #!/bin/sh fdb=feldon30_testforum fuser=feldon30 fpw=U$fkds0431 fdate=`eval date +%Y-%m-%d` mysql -u $fuser -p$fpw -D $fdb -e "UPDATE tracking SET lastupdate=$fdate;"

  0
• 

  cPanelMichael

  • July 20, 2015 13:19

  I am trying ensure the user I am running a bash script with has full access to my database via a my.conf file that specifies a valid username and password

  
  Hello :) Have you considered authenticating with a MySQL username/password directly in the script as referenced in the previous post? Thank you.

  0

Please sign in to leave a comment.