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?
[ATTACH=CONFIG]n68042[/ATTACH]
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?
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).
sC just install SC. Apache+PHP. Database should be installed and managed independent
The SC docs say they install these.
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.
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.
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.
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
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:
[LIST=1]
(I am on Windows).
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:
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!
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.
[ATTACH=CONFIG]n68223[/ATTACH]
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?
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.
OK thanks… so I changed WAMP back to 80.
Now how do I get ScriptCase to start?
http://127.0.0.1:8081/scriptcase
gives:
Firefox can’t establish a connection to the server at 127.0.0.1:8081.
Probabluy you need to go to Windows Services and start ApacheSC service.
In your development machine, you don’t have to start the Apache service that comes with WAMP. Just MySQL. Scriptcase uses it’s own web server to open the IDE. In your case, the Apache that comes with Scriptcase is listening to port 8081. Make sure you start the Apache that comes with Scriptcase going to Start->Programs->Scriptcase 8 ->Start Webserver.
Thanks for all suggestions - it is working now.
In Task manager, I see 4 Apache entries. Two are for Scriptcase and two are for WAMP.
Is this correct?
[ATTACH=CONFIG]n68270[/ATTACH]
