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
Digital Lifestyle
Web Design and Hosting
Madagawho? MySQL pre-newbie help
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="xstep" data-source="post: 622260" data-attributes="member: 11647"><p>The starting MySQL page is probably <a href="http://dev.mysql.com/usingmysql/get_started.html" target="_blank">http://dev.mysql.com/usingmysql/get_started.html</a> and the Mac one is <a href="http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html</a> which has some interesting notes. You'll want to set your PATH for your shell. That is answered there. That will allow you to enter just the commands rather than whole paths to a command.</p><p></p><p>To see if you can get into mysql, at the terminal prompt type;</p><p style="margin-left: 20px">/usr/local/mysql/bin/mysql -u root -p</p><p>You should be prompted for the root password you created. Enter that then you should see a welcome message and a 'mysql>' prompt.</p><p></p><p>If you got the prompt, then type;</p><p style="margin-left: 20px">show databases;</p><p>I beleive you'll see two, as you haven't yet created one for your project.</p><p></p><p>It isn't normal to control a database via a root password. The norm is to create a database and add a super user that controls that particular database. That user also is the one to add other users and permissions. You'll learn this as you go. I just thought I'd plant the basic thought now.</p><p></p><p>I'd recommend you by a book on MySQL. There are so many to choose from. Perhaps one that also includes a programming language you are using would be best. Read title reviews at Amazon.</p></blockquote><p></p>
[QUOTE="xstep, post: 622260, member: 11647"] The starting MySQL page is probably [url]http://dev.mysql.com/usingmysql/get_started.html[/url] and the Mac one is [url]http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html[/url] which has some interesting notes. You'll want to set your PATH for your shell. That is answered there. That will allow you to enter just the commands rather than whole paths to a command. To see if you can get into mysql, at the terminal prompt type; [INDENT]/usr/local/mysql/bin/mysql -u root -p[/INDENT] You should be prompted for the root password you created. Enter that then you should see a welcome message and a 'mysql>' prompt. If you got the prompt, then type; [INDENT]show databases;[/INDENT] I beleive you'll see two, as you haven't yet created one for your project. It isn't normal to control a database via a root password. The norm is to create a database and add a super user that controls that particular database. That user also is the one to add other users and permissions. You'll learn this as you go. I just thought I'd plant the basic thought now. I'd recommend you by a book on MySQL. There are so many to choose from. Perhaps one that also includes a programming language you are using would be best. Read title reviews at Amazon. [/QUOTE]
Verification
Name this item. 🏈
Post reply
Forums
Digital Lifestyle
Web Design and Hosting
Madagawho? MySQL pre-newbie help
Top