i am rying to create an sql database for the suitecrm, when i try to run it it gives me the error:
Checkt this link:
Thanks,
BrozTechnologies
i followed this example:
C:\Users\user\Downloads\Video\Install SuiteCRM 7.7.9 on windows 10 localhost ( XAMPP 7.1.7 ) - open source PHP CRM byNP - YouTube.mp4
But the only difference is that i am installing on server 2012 r2 machine. what am i doing wrong.
Hi Tochineke,
please describe more detailed how you got this error.
Did you run some commands on the db-cli? If so, which commands?
Did the error appear during the installation wizzard? If so, can you post the current version of all components youāre using (php, mysqlā¦)?
i navigated to localhost/127.0.0.1/phpmyadmin
then to sql to run the following commands shown in this video:
The version is
server 127.0.0.1 via tcp/ip
server type: mariadb
server: 10.4.11-mariadb -
protocol version:10
user: root@localhost
server charset:
webserver:
Apache/2.4.41 (win64) openssl/1.1.1c PHP/7.2.28
database client
php version: 7.2.28
phymyadmin
version information:5.0.1 latest stable version: 4.9.4
I donāt know why people do tutorials that recommend manually creating the database for SuiteCRM, when the SuiteCRM installer is able to do that since the beginning.
I DO NOT recommend manual creation of database. Just let the installer do it.
And I wish all those tutorials would be corrected or removedā¦ many of them just make things more complicated than they really areā¦
When i try to do automatically, it brings up an error message that the database, username and password is not correct.
You can try those credentials first in the command-line, calling
mysql -u user -p password
Once you get them right, SuiteCRM will also be able to use them. They need admin access (or at least, the ability to create tables and indexes).
If that fails sometimes itās because of the way youāre referencing your server address, or due to unusual ports.
Check install.log
and php_errors.log
(or whatever your PHP error log is called in your php.ini
) for clues.
The problem is i am relatively new to this. how do i do it automatically? what steps do i need to navigate to what you showed me?
Hey,
- open xampp, then click the button labeled āshellā
- enter
mysql -u<Username> -p
, so for examplemysql -usuite -p
(assuming your db user is called āsuiteā, otherwise change this command accordingly. Alternatively, for a test system, you could reuse the ārootā account). Hit enter. - Enter the password and hit enter
- If you get an error message, post it here. If you see something like
MariaDB > _
, the credentials are fine. Run the installer again and use localhost/username/password to set up SuiteCRM.
This is what i got:
Administrator@WIN-04C4FRBGF5D c:\xampp
mysql -root -p
Enter password: ****
ERROR 1045 (28000): Access denied for user āAdministratorā@ālocalhostā (using pa
ssword: YES)
Administrator@WIN-04C4FRBGF5D c:\xampp
myql -test -p
āmyqlā is not recognized as an internal or external command,
operable program or batch file.
Administrator@WIN-04C4FRBGF5D c:\xampp
mysql -test -p
Enter password: ****
ERROR 1045 (28000): Access denied for user āAdministratorā@ālocalhostā (using pa
ssword: YES)
Administrator@WIN-04C4FRBGF5D c:\xampp
It might not be relevant bur are you installing under XAMPP or under IIS Server? I have install it under both circumstances and so far windows server has been the most painful?
Check here:
Thanks,
AlxGr
Your password is not working. You need access to your DB in order to install SuiteCRMā¦
You need to figure out which password was used when the database software was installed. If you donāt have it, then you would need to reinstall it (assuming you donāt have any other databases in that server that need to stay operational).
Hi,
you misspelled the command. It is
mysql -uUsername -p
instead of
mysql -Username -p
Thatās why the console is returning
Access denied for user āAdministratorā@ālocalhostā (using pa ssword: YES)
instead of ātestā@ālocalhostā (or ārootā@ālocalhostā). Therefore, you might have the correct password, but didnāt use the respective user.
Hello dilligent,
What you showed me, i am still having the same error. i have not created any user or password, so i think that it is why is it giving me the error.
while installing i was never asked for any password.
Just try
mysql -uroot
maybe your root account can be used from localhost without a password. In case this works, just leave the password field blank while installing Suite.
But: for a productive system you should set up a DB user for each application such as Suite.