Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
macOS & iOS Developer Playground
macOS - Development and Darwin
MySQL password retardation
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mrtojamura" data-source="post: 21990"><p>Gosh darnit!</p><p></p><p>Does anyone have any clue why I am having problems setting the root password for mysql?</p><p></p><p>I've been following the hand-dany tutorial on the O'Reilly website about Apache/PHP/MySQL but have gotten stuck on a seemingly basic problem. Having installed mysql ok when I go to set the root user password using these two recommended commands:</p><p></p><p> /usr/local/mysql/bin/mysqladmin -u root password <password></p><p> /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password></p><p></p><p>The first command works fine but the second brings up an error:</p><p></p><p> connect to server at 'pd.local.' failed</p><p> error: 'Host '192.168.2.36' is not allowed to connect to this MySQL server'</p><p></p><p>Anyone have a clue why?</p><p></p><p>Might it be because of the IP address of the host being on a LAN?</p><p></p><p>I've searched around and can't find any advice.... anyone?</p></blockquote><p></p>
[QUOTE="mrtojamura, post: 21990"] Gosh darnit! Does anyone have any clue why I am having problems setting the root password for mysql? I've been following the hand-dany tutorial on the O'Reilly website about Apache/PHP/MySQL but have gotten stuck on a seemingly basic problem. Having installed mysql ok when I go to set the root user password using these two recommended commands: /usr/local/mysql/bin/mysqladmin -u root password <password> /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password> The first command works fine but the second brings up an error: connect to server at 'pd.local.' failed error: 'Host '192.168.2.36' is not allowed to connect to this MySQL server' Anyone have a clue why? Might it be because of the IP address of the host being on a LAN? I've searched around and can't find any advice.... anyone? [/QUOTE]
Verification
Post reply
Forums
macOS & iOS Developer Playground
macOS - Development and Darwin
MySQL password retardation
Top