Announcement

Collapse
No announcement yet.

First time user: What is MySQL password for root?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • First time user: What is MySQL password for root?

    Hello

    I have just installed the demo and started working thru the video course.
    What is the password for MySQL user root?
    Unfortunately in the video the user just types in a password without saying what she used.

    I tried empty, mysql, admin, root. Nothing works.

    Can someone tell me what password to use?

    2016-05-05_12-00-26.jpg

  • #2
    It depends on your MySQL instance. At installation time you had to give the root's password to use. If you haven't installed it then you need to ask for it at the guy that did. Other option is to leave the password empty, some people do that for local instances.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Originally posted by aducom View Post
      It depends on your MySQL instance. At installation time you had to give the root's password to use. If you haven't installed it then you need to ask for it at the guy that did. Other option is to leave the password empty, some people do that for local instances.
      I simply downloaded the Scriptcase install exe file and ran that. It did not ask me for a root password (as far as I remember).
      I did a local install onto my Windows 8.1 PC.

      I tried leaving the password empty, but it doesnt like that.

      Did I need to install something else? Or what password can I use?






      Comment


      • #4
        A thought: Perhaps the install does not install MySQL? I assumed Scriptcase installed everything I need.

        (I dont have MySQL on my PC and have never used it).

        Comment


        • #5
          sC just install SC. Apache+PHP. Database should be installed and managed independent
          /Giuseppe

          Professional Scriptcase Services
          Some Customers opinions

          Comment


          • #6
            Originally posted by Giu View Post
            sC just install SC. Apache+PHP. Database should be installed and managed independent
            The SC docs say they install these.


            Comment


            • #7
              Scriptcase supports the database listed in the connection area. But it doesn't install any databases, you need to have the database already installed so that you can use it with Scriptcase. You can download Mysql at there official site.

              http://dev.mysql.com/downloads/mysql/

              Comment


              • #8
                Best solution imho is to install Wamp if you are on windows. Then you get a regular webserver, php, mysql instance you can use to deploy your scriptcase locally and test outside of scriptcase before bringing it all to your production server. Easy to install and a proven solution.
                Albert Drent
                aducom software netherlands
                scriptcase partner, reseller, support and (turn-key) development
                www.scriptcase.eu / www.scriptcase.nl

                Comment


                • #9
                  Wait! Before install Xamp or Wamp, take a look to the logs, in recent versions of mysql the password is printed at the log file. For example, in my linux machine I found this line:

                  [Note] A temporary password is generated for root@localhost: blablabla
                  Note: I do not know where mysql's log are in windows version. So, firstly find the log and then take a look at it.

                  Comment


                  • #10
                    Install WAMP and use root with no password, this will be good for beginners. after installation completed go to http://localhost/phpmyadmin/ and create your database then back to Scriptcase to complete your project.

                    Good Luck
                    Scriptcase V8.1 Enterprise Edition.

                    Comment


                    • #11
                      Thanks for all the suggestions. I now have MySQL working with a known password.

                      For those who suggested install WAMP - can you give me more info, as I am new to WAMP:
                      1. Should I install it, even although I used the Scriptcase setup file already?
                      2. Do you have a recommended site to go to to get a WAMP download file?

                      (I am on Windows).

                      Comment


                      • #12
                        Originally posted by jack123 View Post
                        Thanks for all the suggestions. I now have MySQL working with a known password.

                        For those who suggested install WAMP - can you give me more info, as I am new to WAMP:[*]Should I install it, even although I used the Scriptcase setup file already?

                        Advantage of WAMP is that you get a complete webserver configured with PHP and MySQL working. Most of them are portable.
                        This means you avoid to download apache, php, mysql and configure all of this. Just run, start services and go.

                        You can have SC installed on this WAMP too if you want, using manual installation, or you can use same Apache that comes with SC.


                        [*]Do you have a recommended site to go to to get a WAMP download file?
                        (I am on Windows).

                        WAMP stands for Windows/Apache/mySQL/PHP

                        You have a lot of different wamp solutiones out there:
                        - WAMPServer
                        - EasyPHP
                        - AppServ
                        - Uniform Server
                        - Bitnami
                        - ...A lot more.

                        You can use WNMP too, it's the same but using Nginx instead Apache.
                        I like Uniform Server for development, testing and production enviroments too. Is just a personal preference, not because is better than others.

                        The advantage of use an alternative web server in your machine, is you can deploy your app on this alternative local​ server to see if your app is working correctly. For example, I have several folders with UniformServer with different configurations (mysql/mariadb versions, PHP 7 and so on...), my SC instance is working with PHP 5.6 I can test my projects under PHP 7 without deploying outside my machine. I just have to start Uniform instance I need, and go. When I don't need my alternative apache, I start Uniform and shutdown Apache, and I left MySQL on only.

                        I hope I explained correctly.
                        /Giuseppe

                        Professional Scriptcase Services
                        Some Customers opinions

                        Comment


                        • #13
                          Originally posted by Giu View Post


                          Advantage of WAMP is that you get a complete webserver configured with PHP and MySQL working. Most of them are portable.
                          This means you avoid to download apache, php, mysql and configure all of this. Just run, start services and go.

                          You can have SC installed on this WAMP too if you want, using manual installation, or you can use same Apache that comes with SC.





                          WAMP stands for Windows/Apache/mySQL/PHP

                          You have a lot of different wamp solutiones out there:
                          - WAMPServer
                          - EasyPHP
                          - AppServ
                          - Uniform Server
                          - Bitnami
                          - ...A lot more.

                          You can use WNMP too, it's the same but using Nginx instead Apache.
                          I like Uniform Server for development, testing and production enviroments too. Is just a personal preference, not because is better than others.

                          The advantage of use an alternative web server in your machine, is you can deploy your app on this alternative local​ server to see if your app is working correctly. For example, I have several folders with UniformServer with different configurations (mysql/mariadb versions, PHP 7 and so on...), my SC instance is working with PHP 5.6 I can test my projects under PHP 7 without deploying outside my machine. I just have to start Uniform instance I need, and go. When I don't need my alternative apache, I start Uniform and shutdown Apache, and I left MySQL on only.

                          I hope I explained correctly.
                          Thanks for this information. Very useful. I will look at Uniform Server
                          first!

                          Comment


                          • #14
                            Originally posted by Giu View Post


                            Advantage of WAMP is that you get a complete webserver configured with PHP and MySQL working. Most of them are portable.
                            This means you avoid to download apache, php, mysql and configure all of this. Just run, start services and go.

                            You can have SC installed on this WAMP too if you want, using manual installation, or you can use same Apache that comes with SC.
                            I took the advice and installed WAMP (WampServer Version 3). It runs OK and I can get into phpMyAdmin.

                            However, ScriptCase does not start.
                            http://127.0.0.1:8081/scriptcase
                            gives:
                            The requested URL /scriptcase was not found on this server.
                            Apache/2.4.18 (Win32) PHP/5.6.19 Server at 127.0.0.1 Port 8081
                            WAMP uses port 80 by default. Because ScriptCase wants to use Port 8081, I guessed that I should change WAMP to also use 8081. I did this using the WAMP tools option (see picture), but that did not help.

                            2016-05-09_16-12-25.jpg

                            I had ScriptCase working before installing WAMP, but now it does not run.

                            Should I uninstall ScriptCase and install it again? If so, will WAMP automatically use it correctly, or are there some steps I should follow?


                            Comment


                            • #15
                              No, If you set your alternative apache to 8081 as well, one of both will not start. But, for mySQL you don't need to start apache for anything.
                              /Giuseppe

                              Professional Scriptcase Services
                              Some Customers opinions

                              Comment

                              Working...
                              X