12/17/2023 0 Comments Tableplus connect to mysql![]() In order to specify a config file use redis-server /path/to/nf Redis_1 | 1:C 22:59:46.908 # Warning: no config file specified, using the default config. Mailhog_1 | 7 22:59:46 Using in-memory storage Not sure if can give any additional inside Here are some of the logs that I see once I do sail up. No luck at all with mysql even if I try to connect via tableplus. SQLSTATE Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')ĪPP_NAME=Laravel APP_ENV=local APP_KEY=base64:3D+vBleTpoar34U8B2B0NKR3NEp1nxrXbecrL7bJUGE= APP_DEBUG=true APP_URL= LOG_CHANNEL=stack LOG_LEVEL=debug DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel DB_USERNAME=root DB_PASSWORD= BROADCAST_DRIVER=log CACHE_DRIVER=file QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120 MEMCACHED_HOST=127.0.0.1 REDIS_HOST=127.0.0.1 REDIS_PASSWORD=null REDIS_PORT=6379 MAIL_MAILER=smtp MAIL_HOST=mailhog MAIL_PORT=1025 MAIL_USERNAME=null MAIL_PASSWORD=null MAIL_ENCRYPTION=null MAIL_FROM_ADDRESS=null MAIL_FROM_NAME="$:6379' volumes: - 'sailredis:/data' networks: - sail # memcached: # image: 'memcached:alpine' # ports: # - '11211:11211' # networks: # - sail mailhog: image: 'mailhog/mailhog:latest' ports: - 1025:1025 - 8025:8025 networks: - sail networks: sail: driver: bridge volumes: sailmysql: driver: local sailredis: driver: localĪnyone has any ideas. Trying to even run > sail artisan migrate throws the following message: ![]() ![]() ![]() I got everything working (I think) except being able to connect to mysql. Now, go back to TablePlus and access your database again.On an existing project, decided to give a try to Sail. To make sure everything is good, restart mysql server. # localhost which is more compatible and is not less secure. # Instead of skip-networking the default is now to listen only on You can use vim to edit this, vim /etc/mysql//mysqld.cnf. You have to edit the mysqld.cnf file and uncomment the bind-address. This should work now, but Ubuntu 18.04.1 comes with a MySQL configuration that has a default secure connection that we need to take care of. GRANT ALL PRIVILEGES ON *.* TO flush the privileges to update any records. CREATE USER USER 'YOUR_NEW_USER' identified by 'YOUR_PASSWORD' Above code is depreciated and you can do this alternative approach. If you’re using a higher version of MySQL like the 8.0, you’ll get an error like “ ERROR 1064 (42000): You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near ‘identified by “Your_password”‘ at line 1“. grant all privileges on *.* to identified by "YOUR_PASSWORD" Then enter the following commands, make sure to change the default data. To do this, access your mysql via mysql -u -root -p. To grant a remote access to MySQL server, you need to create a database user with a host wildcard “%”. There are only two causes that cause this problem, either by a database user no remote access or a configuration file. You probably get an error message that says “Driver Error, Can’t connect to MySQL server on ‘YOUR_IP_ADDRESS’ (10061)”. If you recently installed MySQL server in DigitalOcean or Upcloud and you use TablePlus on connecting to the server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |