Jump to content



Photo

Question On Mysql


  • Please log in to reply
7 replies to this topic

#1 Julio

Julio

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 22 May 2012 - 9:36 PM

I tried to Install MySQL and accidentally typed an wrong password (mistake from copy paste) : the password I think is new-password. But it also may not be so. The truth being Followint the appendix a on the third edition of Larrys MySQL and PHP:Dynamic websites book returned a connection failed error with password : NO.

this is what it returns now:

unknown-00-17-f2-c4-cd-70:bin juliositgespomares$ mysqladmin –u root password ➝ 0bservar8
-bash: mysqladmin: command not found
unknown-00-17-f2-c4-cd-70:bin juliositgespomares$

I tried to show you what I wrote before since it is what I saw, but it returned something different.

I want to install the environment on My iMac with in tell processor.
And Used the web to figure out how to use the PHP that came with the computer, I have lion installed.

I thought that reinstalling MySQL would set blank the password but I still can't set a password and I need help thoroughly to set my testing environment. So far when I check a php on Safari all i can see is the code (raw) not parsed as Larry writes in his amazing book.

Thanks for the help, it is much appreciated.
j
  • 0

#2 HartleySan

HartleySan

    Advanced Member

  • Members
  • PipPipPip
  • 2,950 posts
  • LocationColumbus, OH USA

Posted 22 May 2012 - 10:57 PM

The info in Larry's 3rd edition is somewhat outdated at this point. When the book was published, you could set a MySQL password during the installation, but you can't do that anymore during the installation.

Hopefully the following link helps:
http://veerasundar.c...mysql-in-xampp/
  • 0

#3 margaux

margaux

    Advanced Member

  • Members
  • PipPipPip
  • 451 posts

Posted 23 May 2012 - 4:07 AM

I want to install the environment on My iMac

you will need to install MAMP, which you can download from this link, http://www.mamp.info/en/index.html. Ensure that you have the correct operating system required. Once you've installed MAMP, you will hve a new test environment and you can use phpmyadmin to set passwords.
  • 0

#4 Julio

Julio

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 23 May 2012 - 10:44 AM

you will need to install MAMP, which you can download from this link, http://www.mamp.info/en/index.html. Ensure that you have the correct operating system required. Once you've installed MAMP, you will hve a new test environment and you can use phpmyadmin to set passwords.


Thank you for this answer, I've actually erased mamp folder and will now proceed to replacing it to its prior location. furthermore I would feel comfortable if any of you could reassure me that It is okay to have made changes on the terminal regarding php module and of course the installation of mysql. What should be the best course of action regarding those two, Would it be a problem to leave those installed as is. I would need to dl a program to let me see hidden files before i can access usr to erase mysql folder.

So Im on the MAMP configuration. again, I'll let you know how it goes.
j-
  • 0

#5 Julio

Julio

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 23 May 2012 - 11:23 AM

I erased MAMP because I thought i did not need it, after putting it back to my applications I see the MySQL server offline, I don't know how to set the password using phpmyadmin, but can read about it online.
i'll let you know how it goes
j-
  • 0

#6 Julio

Julio

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 23 May 2012 - 11:28 AM

Forbidden

You don't have permission to access /MAMP/ on this server.
Apache/2.2.21 (Unix) DAV/2 PHP/5.3.8 with Suhosin-Patch Server at localhost Port 80
I set the MySQL to stop on system preferences (I had downloaded it separately and is still on my computer), now I want to start MAMP MySQL but receive the error above.
  • 0

#7 Julio

Julio

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 23 May 2012 - 11:29 AM

YAY success!
Its working apparently it worker stopping MySQL on system preferences
  • 0

#8 Julio

Julio

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 23 May 2012 - 11:32 AM

Short lived happy moment, Its back on red. "(
  • 0