ホーム > 開発環境 > mysql5.5で新規ユーザ追加

mysql5.5で新規ユーザ追加

2012 年 2 月 2 日 コメントをどうぞ コメント

の基本設定は終わったので、早速使ってみようと思う。

 

まず、いつまでも「root」のみで作業するのは問題がありそうなので、ユーザーの追加をすべし。

テスト用DBのみ権限を付ける。

作り方は簡単でした。

mysqlユーザ管理

ほかにもgoogle先生にはたくさんありました「mysql ユーザ作成」とかでググる。

 

あっさり作成して、権限もついたし、早速作成したユーザで、ログイン!!

・・・・・・・・・・

MySQL Error Number 1045
Access denied for user ‘username’@’localhost'[using password YES]

なんかログインできませんメッセージが・・・。

google先生に聞いても答えてくれない。

「パスワード違うんじゃない?」とかいうのばかり・・・・。

ユーザを作り直してもだめ・・・。

 

とにかくいろいろやってみることに・・・。

 

 

しばらくごちゃごちゃやってると・・・・できた!!

いろいろやったので、はっきりとは言えないが、たぶん「匿名ユーザ」というのが邪魔をしていたような気が・・・。

select host, user, password from mysql.user;

で表示される空白のユーザ(追加したわけじゃないので初期状態で存在)。

こいつを削除してやるとログインできた。

なにがどうなってどうなってるんだろうと気になりつつも、とりあえずログインできたので良し。

pass無しの匿名ユーザなんて使わないし・・・。

関連する記事

An interactive test could help wholesale football jerseys flag NFL Jerseys China up whether you should seek advice from a health professional for one of the most common types of cancer. The test is available on the NHS Choices website and reveals whether you are at risk from the disease and recommends http://www.cheap-nfl-nike-jerseys.com if you should seek help. The mole self assessment factors in elements such as complexion, the number of times you replica oakleys have been severely sunburnt and whether skin cancer runs in your family. It also quizzes you on the number of moles you have and whether there have been any changes in appearanceregarding size, shape and colourMaybe someone not argee with me, but what I requirement to intensiveness again is Moncler kids down jackets are really so nice that you deserve to keep one up if you have a child. As a famous kind for outdoor sports, the caring judgment of the downed jackets is no doubtfulness really tall. Hart’s own research is notable for focusing on drugs administered to humans, not rats, in a lab. It has cut against the prevailing conventional wisdom that, for example, crack cocaine users don’t respond to economic alternatives. He serves on the highest body in his field, the National Advisory Council on Drug Abuse, which is affiliated with the National Institutes of Health.Adjust the size of the cells in the graduated parlay card if you intend to use tokens to mark your parlay progress. To mark progress, stack a number of tokens equal to one more than the teams bet on the cell under “0 Losses” next to the number of teams bet. Every time a game finishes that is in your parlay, remove one token, whether you picked it correct or not. Every time a team you picked loses, slide the stack of tokens one cell to the right. Wherever the final token rests after nfl jerseys cheap the games are done shows your payout.Want to listen to your favorite games no matter where you are? Instead of paying for satellite radio service, just pick up this 99 cent app and listen to whatever game you want. It shows all the team schedules, so just find the one you want and the app lets you tune right into the game.A rival stadium project in Inglewood, backed by St. Louis Rams owner Stan Kroenke, would have a roof though it is open air on the sides and artificial turf. It would be set 100 feet into the ground. In Carson, the plan is to have seating at ground level and use natural grass.Then there’s Dr. Claw: Not only do we never see his face in the show (the action figure that revealed it came out years after the show had NBA Jerseys Cheap gone off the air), but the only thing we see is his metal hand, almost like an artificial limb. Also, his voice sounds like someone fellating a garbage disposal it’s pretty obvious that Claw was involved in some sort of accident, wholesale nfl jersyes too. Coincidence? We think not.

関連する記事

カテゴリー: 開発環境 タグ:
  1. コメントはまだありません。
  1. トラックバックはまだありません。