Php Connection issue(SQL STATE 2002) with MySQL while connection string is right

1 answer

I couldn't push schema changes to MySQL DB from terminal.

I'm always getting 2002 error.

enter image description here

I have installed MySQL. It's up and running.

I'm using MAMP.

Here is my .env file

# In all environments, the following files are loaded if they exist, # the latter taking precedence over the former: # #  * .env                contains default values for the environment variables needed by the app #  * .env.local          uncommitted file with local overrides #  * .env.$APP_ENV       committed environment-specific defaults #  * .env.$APP_ENV.local uncommitted environment-specific overrides # # Real environment variables win over .env files. # # DO NOT DEFINE PRODUCTION SECRETS IN THIS FILE NOR IN ANY OTHER COMMITTED FILES. # # Run "composer dump-env prod" to compile .env files for production use (requires symfony/flex >=1.2). # https://symfony.com/doc/current/best_practices.html#use-environment-variables-for-infrastructure-configuration  ###> symfony/framework-bundle ### APP_ENV=dev APP_SECRET=f492b5be321d353dbb48352876d4db75 #TRUSTED_PROXIES=127.0.0.0/8,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16 #TRUSTED_HOSTS='^(localhost|example\.com)$' ###< symfony/framework-bundle ###  ###> symfony/mailer ### # MAILER_DSN=smtp://localhost ###< symfony/mailer ###  ###> doctrine/doctrine-bundle ### # Format described at https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url # For an SQLite database, use: "sqlite:///%kernel.project_dir%/var/data.db" # For a PostgreSQL database, use: "postgresql://db_user:db_password@127.0.0.1:5432/db_name?serverVersion=11&charset=utf8" # IMPORTANT: You MUST configure your server version, either here or in config/packages/doctrine.yaml DATABASE_URL=mysql://sampleUserName:SamplePassword@127.0.0.1:3306/prod_cat?serverVersion=5.7 ###< doctrine/doctrine-bundle ### 

Here is my doctrine.yaml

doctrine:     dbal:         url: '%env(resolve:DATABASE_URL)%'         mapping_types:             enum: string        #        unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock          # IMPORTANT: You MUST configure your server version,         # either here or in the DATABASE_URL env var (see .env file) #        server_version: '5.7'     orm:         auto_generate_proxy_classes: true         naming_strategy: doctrine.orm.naming_strategy.underscore_number_aware         auto_mapping: true         mappings:             App:                 is_bundle: false                 type: annotation                 dir: '%kernel.project_dir%/src/Entity'                 prefix: 'App\Entity'                 alias: App 

To make it easy below I'm mentioning connecting string from .env file

 DATABASE_URL=mysql://sampleUserName:SamplePassword@127.0.0.1:3306/prod_cat?serverVersion=5.7 

FYI:

  • Apache & MySQL is up and running.

  • MySQL version number I have mentioned is right

  • The user name and password is right.

All answers to this question, which has the identifier 61178988

The best answer:

This could be an issue where there is a mismatch in port number of MySQL and What's in Connection String.

Find port number of MySQL by visiting MySQL page in PhpMyAdmin and use the port number in your Connection String or else use the port number of connection string in MySQL port setting.

To change the MySQL Port. Go to Preferences in MAMP and Choose Ports tab and you can update it there.

enter image description here

Last questions

how do i remove the switch on my home screen?
how to edit the JS date and time to update atuomatically?
How to utilize data stored in a multidimensional array
Powermockito not mocking URL constructor in URI.toURL() method
Android Bluetooth LE Scanner only scans when phone's Location is turned on in some devices
docker wordpress container can't connect to mysql container
How can I declare a number in java that is more than 64-bits? [duplicate]
Optaplanner solutionClass entityCollectionProperty should never return null error when simple JSON object passed to controller
Anylogic, get the time a pedestrain is in a queue
How do I fix this syntax issue with my .flex file?
Optimizing query in PHP
How to find the highest number of a column and print two columns of that row in R?
Ideas on “Error: Type com.google.firebase.iid.zzav is referenced as an interface from com.google.firebase.messaging.zzd”?
JCIFS SmbFile.exists() and SmbFile.isDirectory() return false when it exists and I can listFiles()
PHP total order
Laravel booking system design
neural net - undefined column selected
How to indicate y axis does not start from 0 in ggplot?
Fragments in backStack
Spinner how to change the data